DBA Data[Home] [Help]

APPS.OE_INV_IFACE_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 372: SELECT mtl_material_transactions_s.nextval

368:
369:
370: -- we will use this transaction_header_id for all
371: -- interface lines
372: SELECT mtl_material_transactions_s.nextval
373: INTO l_transaction_header_id
374: FROM dual;
375:
376: l_transaction_interface_id := l_transaction_header_id;

Line 754: SELECT mtl_material_transactions_s.nextval

750: FROM dual;
751:
752: --ER 8419373 check if lot and serial controlled and get new transaction_interface_id for column SERIAL_TRANSACTION_TEMP_ID
753: IF l_lot = 'Y' AND l_serial = 'Y' THEN
754: SELECT mtl_material_transactions_s.nextval
755: INTO l_serial_transaction_temp_id
756: FROM dual;
757: else
758: l_serial_transaction_temp_id := null;

Line 1155: SELECT mtl_material_transactions_s.nextval

1151: l_line_rec.task_id
1152: FROM gl_code_combinations
1153: WHERE code_combination_id = l_trans_acc;
1154:
1155: SELECT mtl_material_transactions_s.nextval
1156: INTO l_transaction_interface_id
1157: FROM dual;
1158: -- for use when looping or used by the second
1159: -- insert into mtl_transactions_interface