APPS.OE_DS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 494: SELECT mtl_material_transactions_s.nextval

490: ** Will use this sequence for inserting all records in
491: ** MTL_INTERFACE tables during decrement inventory
492: */
493:
494: SELECT mtl_material_transactions_s.nextval
495: INTO l_lot_set_id
496: FROM dual;
497:
498: IF l_lot_quantity <> -1 THEN

Line 849: value we got from mtl_material_transactions_s sequence.

845:
846: IMPORTANT: ALL THE RECORDS INSERTED IN THE ABOVE TABLE FOR A
847: PARTICULAR TRANSACTION HAVE THE SAME TRANSACTION_INTERFACE_ID.
848: We pass the p_transaction_header_id to this API which is
849: value we got from mtl_material_transactions_s sequence.
850: This value is assigned to the TRANSACTION_INTERFACE_ID.
851:
852:
853: ----------------------------------------------------------------------- */

Line 1057: SELECT mtl_material_transactions_s.nextval

1053: p_sn_control_code = 5 OR
1054: p_sn_control_code = 6)
1055: THEN
1056:
1057: SELECT mtl_material_transactions_s.nextval
1058: INTO l_serial_set_id
1059: FROM dual;
1060:
1061: DECLARE