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.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_SHIPPING_NETWORK_VIEW

Line 2841: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2837: -- Modified for fob stamping project
2838: IF (p_transfer_organization_id IS NOT NULL) THEN
2839: IF p_transaction_action_id = 21 THEN /* Intransit Shipment */
2840: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2841: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2842: WHERE MSNV.from_organization_id = p_organization_id
2843: AND MSNV.to_organization_id = p_transfer_organization_id
2844: AND MMT.transaction_id = p_transaction_id;
2845: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */

Line 2847: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2843: AND MSNV.to_organization_id = p_transfer_organization_id
2844: AND MMT.transaction_id = p_transaction_id;
2845: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */
2846: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2847: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2848: WHERE MSNV.from_organization_id = p_transfer_organization_id
2849: AND MSNV.to_organization_id = p_organization_id
2850: AND MMT.transaction_id = p_transaction_id;
2851: END IF;

Line 6568: FROM mtl_shipping_network_view MSNV,

6564: /****** Get FOB POINT ******/
6565: IF (l_xfer_organization_id IS NOT NULL) THEN
6566: IF l_transaction_action_id = 21 THEN /* Intransit Shipment */
6567: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
6568: FROM mtl_shipping_network_view MSNV,
6569: mtl_material_transactions MMT
6570: WHERE MSNV.from_organization_id = l_organization_id
6571: AND MSNV.to_organization_id = l_xfer_organization_id
6572: AND MMT.transaction_id = p_transaction_id;

Line 6576: FROM mtl_shipping_network_view MSNV,

6572: AND MMT.transaction_id = p_transaction_id;
6573: ELSIF l_transaction_action_id = 12 THEN /* Intransit Receipt */
6574: SELECT nvl(MMT.fob_point, MSNV.fob_point)
6575: INTO l_fob_point
6576: FROM mtl_shipping_network_view MSNV,
6577: mtl_material_transactions MMT
6578: WHERE MSNV.from_organization_id = l_xfer_organization_id
6579: AND MSNV.to_organization_id = l_organization_id
6580: AND MMT.transaction_id = p_transaction_id;