DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on RCV_TRANSACTIONS_INTERFACE_S

Line 1313: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

1309: PO_HEADER_ID,
1310: PO_LINE_ID,
1311: SHIP_TO_LOCATION_ID
1312: ) VALUES (
1313: PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1314: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,
1315: PO.RCV_INTERFACE_GROUPS_S.CURRVAL,
1316: SYSDATE,
1317: FND_GLOBAL.USER_ID,

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

2190:
2191: --Initialize the sequences that are to be used.
2192: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;
2193: SELECT PO.RCV_INTERFACE_GROUPS_S.NEXTVAL INTO l_group_id FROM sys.dual;
2194: SELECT PO.RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL INTO l_intf_transaction_id from sys.dual;
2195: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL INTO l_mtl_transaction_id from sys.dual;
2196:
2197: --select the user related ids
2198: SELECT FND_GLOBAL.USER_ID INTO l_user_id from sys.dual;