eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_DS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

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

Line 1072: AND exists (select 1 from mtl_material_transactions mmt, rcv_transactions rt

1068: AND nvl(msn.current_subinventory_code,' ') = p_secondary_inventory
1069: AND nvl(msn.current_locator_id,0) = nvl(p_locator_id,0)
1070: AND msn.current_status=3
1071: AND msn.group_mark_id is NULL
1072: AND exists (select 1 from mtl_material_transactions mmt, rcv_transactions rt
1073: where mmt.transaction_id = msn.last_transaction_id
1074: and mmt.transaction_source_type_id = 1
1075: and rt.transaction_id = p_transaction_id
1076: and rt.transaction_id = mmt.rcv_transaction_id