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.

[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 87: FROM csd_product_transactions cpt,mtl_material_transactions mmt

83: WHERE rsl.requisition_line_id = l_requisition_line_id
84: AND rsh.shipment_header_id = rsl.shipment_header_id
85: AND nvl(rsl.quantity_received,0) = 0
86: AND rsl.mmt_transaction_id IN (SELECT mmt.transaction_id
87: FROM csd_product_transactions cpt,mtl_material_transactions mmt
88: WHERE cpt.delivery_detail_id = mmt.picking_line_id
89: AND cpt.product_transaction_id = p_product_txn_id
90: UNION ALL
91: SELECT mmt.transaction_id

Line 92: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt

88: WHERE cpt.delivery_detail_id = mmt.picking_line_id
89: AND cpt.product_transaction_id = p_product_txn_id
90: UNION ALL
91: SELECT mmt.transaction_id
92: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt
93: WHERE cpt.delivery_detail_id = wdd.split_from_delivery_detail_id
94: AND cpt.order_header_id = wdd.source_header_id
95: AND wdd.source_code = 'OE'
96: AND cpt.product_transaction_id = p_product_txn_id

Line 1838: FROM csd_product_transactions cpt,mtl_material_transactions mmt

1834: AND rsl.shipment_header_id = rsh.shipment_header_id
1835: AND rt.transaction_type = 'RECEIVE'
1836: AND rt.shipment_header_id = rsh.shipment_header_id
1837: AND rsl.mmt_transaction_id IN (SELECT mmt.transaction_id
1838: FROM csd_product_transactions cpt,mtl_material_transactions mmt
1839: WHERE cpt.delivery_detail_id = mmt.picking_line_id
1840: AND cpt.product_transaction_id = p_product_txn_id
1841: UNION ALL
1842: SELECT mmt.transaction_id

Line 1843: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt

1839: WHERE cpt.delivery_detail_id = mmt.picking_line_id
1840: AND cpt.product_transaction_id = p_product_txn_id
1841: UNION ALL
1842: SELECT mmt.transaction_id
1843: FROM wsh_delivery_details wdd, csd_product_transactions cpt,mtl_material_transactions mmt
1844: WHERE cpt.delivery_detail_id = wdd.split_from_delivery_detail_id
1845: AND cpt.order_header_id = wdd.source_header_id
1846: AND wdd.source_code = 'OE'
1847: AND cpt.product_transaction_id = p_product_txn_id

Line 2238: mtl_material_transactions_temp mmtt,

2234: l_move_order_line_id,G_DELIVERY_DETAIL_ID
2235: FROM wsh_delivery_details wdd,
2236: mtl_txn_request_headers mtrh,
2237: mtl_txn_request_lines mtrl,
2238: mtl_material_transactions_temp mmtt,
2239: csd_product_transactions cpt
2240: WHERE wdd.delivery_detail_id = cpt.delivery_detail_id
2241: AND cpt.product_transaction_id = p_product_txn_id
2242: AND wdd.move_order_line_id = mtrl.line_id