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 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

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

1043: AND nvl(msn.current_subinventory_code,' ') = p_secondary_inventory
1044: AND nvl(msn.current_locator_id,0) = nvl(p_locator_id,0)
1045: AND msn.current_status=3
1046: AND msn.group_mark_id is NULL
1047: AND exists (select 1 from mtl_material_transactions mmt, rcv_transactions rt
1048: where mmt.transaction_id = msn.last_transaction_id
1049: and mmt.transaction_source_type_id = 1
1050: and rt.transaction_id = p_transaction_id
1051: and rt.transaction_id = mmt.rcv_transaction_id