DBA Data[Home] [Help]

APPS.AHL_OSP_RCV_PVT dependencies on RCV_HEADERS_INTERFACE_S

Line 1030: PO.RCV_HEADERS_INTERFACE_S.NEXTVAL,

1026: VENDOR_ID,
1027: VENDOR_SITE_ID,
1028: SHIP_TO_ORGANIZATION_ID
1029: ) VALUES (
1030: PO.RCV_HEADERS_INTERFACE_S.NEXTVAL,
1031: PO.RCV_INTERFACE_GROUPS_S.NEXTVAL,
1032: 'PENDING',
1033: 'VENDOR',
1034: 'NEW',

Line 1084: PO.RCV_HEADERS_INTERFACE_S.CURRVAL,

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,
1088: FND_GLOBAL.LOGIN_ID,

Line 1915: SELECT PO.RCV_HEADERS_INTERFACE_S.NEXTVAL INTO l_intf_hdr_id FROM sys.dual;

1911: END IF;
1912: END IF;
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: