DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 1083: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

1079: PO_HEADER_ID,
1080: PO_LINE_ID,
1081: SHIP_TO_LOCATION_ID
1082: ) VALUES (
1083: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1084: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1085: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1086: SYSDATE,
1087: FND_GLOBAL.USER_ID,

Line 1917: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;

1913:
1914: --Initialize the sequences that are to be used.
1915: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
1916: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
1917: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
1918: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
1919:
1920: --select the user related ids
1921: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;