[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
rcv_headers_interface_s.NEXTVAL
, rcv_interface_groups_s.NEXTVAL
INTO
l_rcv_header_id
, l_group_id
FROM
dual;
INSERT INTO RCV_HEADERS_INTERFACE
( header_interface_id
, group_id
, processing_status_code
, receipt_source_code
, transaction_type
, last_update_date
, last_updated_by
, creation_date
, created_by
, vendor_id
, VENDOR_SITE_ID
, validation_flag
, Ship_To_Organization_id
, expected_receipt_date
)
VALUES(
l_rcv_header_id
, l_group_id
, 'PENDING'
, 'VENDOR'
, 'NEW'
, SYSDATE
, fnd_global.LOGIN_ID
, SYSDATE
, fnd_global.CONC_LOGIN_ID
, p_vendor_id
, p_vendor_site_id
, 'Y'
, p_ship_to_org_id
, SYSDATE);
INSERT INTO RCV_TRANSACTIONS_INTERFACE
( interface_transaction_id
, header_interface_id
, group_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, transaction_type
, transaction_date
, processing_status_code
, processing_mode_code
, transaction_status_code
, quantity --quantity
, unit_of_measure --uom
, auto_transact_code
, receipt_source_code
, source_document_code
, po_header_id
, po_line_id
, validation_flag
, subinventory
, parent_transaction_id
, po_line_location_id
, locator_id
, project_id
, from_subinventory
, from_locator_id
, replenish_order_line_id
)
SELECT
RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
, p_rcv_header_id
, p_group_id
, SYSDATE
, fnd_global.LOGIN_ID
, SYSDATE
, fnd_global.LOGIN_ID
, p_transaction_type -- 'RECEIVE' -- 'SHIP',
, SYSDATE
, 'PENDING'
, 'BATCH'
, 'PENDING'
, p_quantity
, p_unit_of_measure
, p_auto_transact_code -- 'RECEIVE', --'DELIVER'
, 'VENDOR'
, 'PO'
, p_po_header_id
, p_po_line_id
, 'Y'
, p_subinventory
, p_parent_transaction_id
, p_po_line_location_id
, p_locator_id
, p_project_id
, p_from_subinventory
, p_from_locator_id
, p_replenish_order_line_id
FROM DUAL;