Interface的开发是Oracle ERP中重要的组成部分。
INSERT INTO po_requisitions_interface_all
( transaction_id,
interface_source_code,
source_type_code,
requisition_type,
destination_type_code,
authorization_status,
batch_id,
preparer_id,
note_to_approver,
header_description,
header_attribute1,
header_attribute2,
header_attribute3,
header_attribute4,
header_attribute5,
line_type_id,
destination_organization_id,
item_id,
item_description,
unit_of_measure,
quantity,
unit_price,
need_by_date,
deliver_to_location_id,
deliver_to_requestor_id,
charge_account_id,
project_id,
task_id,
expenditure_organization_id,
expenditure_type,
expenditure_item_date,
suggested_buyer_id,
suggested_vendor_name,
suggested_vendor_site,
suggested_vendor_contact,
suggested_vendor_phone,
note_to_buyer,
justification,
line_attribute1,
line_attribute2,
line_attribute3,
line_attribute4,
line_attribute7,
line_attribute8,
line_attribute9,
org_id,
currency_code,
project_accounting_context,
note_to_receiver )
VALUES ( v_transaction_id,
'CMCC_IMPORT',
'VENDOR',
'PURCHASE',
decode(rec_interface_line.inventory_item_flag, 'Y', 'INVENTORY', 'EXPENSE'),
'INCOMPLETE',
p_batch_id,
p_preparer_id,
rec_interface_line.note_to_authorizer,
rec_interface_line.description,
rec_interface_line.department,
rec_interface_line.budget_type,
rec_interface_line.budget_property,
rec_interface_line.urgency,
rec_interface_line.gross_value,
rec_interface_line.line_type_id,
rec_interface_line.organization_id,
rec_interface_line.item_id,
rec_interface_line.item_description,
rec_interface_line.unit_of_measure,
rec_interface_line.quantity,
rec_interface_line.unit_price,
rec_interface_line.need_by_date,
rec_interface_line.deliver_to_location_id,
nvl(rec_interface_line.to_person_id, p_preparer_id),
rec_interface_line.charge_account_id,
rec_interface_line.project_id,
rec_interface_line.task_id,
decode(rec_interface_line.expenditure_organization_id, NULL, NULL,
decode(rec_interface_line.process_by_cadre_flag, 'Y', fnd_global.org_id,
rec_interface_line.expenditure_organization_id)),
decode(rec_interface_line.expenditure_organization_id, NULL, NULL,
rec_interface_line.expenditure_type),
decode(rec_interface_line.expenditure_organization_id, NULL, NULL,
rec_interface_line.expenditure_item_date),
rec_interface_line.suggested_buyer_id,
rec_interface_line.suggested_vendor_name,
decode(rec_interface_line.suggested_vendor_name, NULL, NULL,
rec_interface_line.suggested_vendor_site),
rec_interface_line.suggested_vendor_contact,
rec_interface_line.suggested_vendor_phone,
rec_interface_line.note_to_agent,
rec_interface_line.justification,
rec_interface_line.supply_cycle, -- attribute1
rec_interface_line.charge_cost_center, -- attribute2
rec_interface_line.charge_purpose, -- attribute3
rec_interface_line.charge_service_brand, -- attribute4
v_transaction_id, -- attribtue7
rec_interface_line.import_request_id, -- attribute8
rec_interface_line.line_num_to_sort, -- attribute9
decode(rec_interface_line.process_by_cadre_flag, 'Y', fnd_global.org_id,
rec_interface_line.org_id),
rec_interface_line.currency_code,
decode(rec_interface_line.project_id, NULL, 'N', 'Y'),
-- Concate these three fields into one NOTE_TO_RECEIVER
rec_interface_line.receiver_location || '|' ||
rec_interface_line.receiver_contact || '|' ||
rec_interface_line.receiver_phone );
