APPS.OE_DS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 483: SELECT mtl_material_transactions_s.nextval

479: ** Will use this sequence for inserting all records in
480: ** MTL_INTERFACE tables during decrement inventory
481: */
482:
483: SELECT mtl_material_transactions_s.nextval
484: INTO l_lot_set_id
485: FROM dual;
486:
487: IF l_lot_quantity <> -1 THEN

Line 824: value we got from mtl_material_transactions_s sequence.

820:
821: IMPORTANT: ALL THE RECORDS INSERTED IN THE ABOVE TABLE FOR A
822: PARTICULAR TRANSACTION HAVE THE SAME TRANSACTION_INTERFACE_ID.
823: We pass the p_transaction_header_id to this API which is
824: value we got from mtl_material_transactions_s sequence.
825: This value is assigned to the TRANSACTION_INTERFACE_ID.
826:
827:
828: ----------------------------------------------------------------------- */

Line 1032: SELECT mtl_material_transactions_s.nextval

1028: p_sn_control_code = 5 OR
1029: p_sn_control_code = 6)
1030: THEN
1031:
1032: SELECT mtl_material_transactions_s.nextval
1033: INTO l_serial_set_id
1034: FROM dual;
1035:
1036: DECLARE