APPS.CST_PRJMFG_COST_COLLECTOR dependencies on MTL_SHIPPING_NETWORK_VIEW

Line 2902: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2898: -- Modified for fob stamping project
2899: IF (p_transfer_organization_id IS NOT NULL) THEN
2900: IF p_transaction_action_id = 21 THEN /* Intransit Shipment */
2901: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2902: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2903: WHERE MSNV.from_organization_id = p_organization_id
2904: AND MSNV.to_organization_id = p_transfer_organization_id
2905: AND MMT.transaction_id = p_transaction_id;
2906: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */

Line 2908: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT

2904: AND MSNV.to_organization_id = p_transfer_organization_id
2905: AND MMT.transaction_id = p_transaction_id;
2906: ELSIF p_transaction_action_id = 12 THEN /* Intransit Receipt */
2907: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
2908: FROM mtl_shipping_network_view MSNV, mtl_material_transactions MMT
2909: WHERE MSNV.from_organization_id = p_transfer_organization_id
2910: AND MSNV.to_organization_id = p_organization_id
2911: AND MMT.transaction_id = p_transaction_id;
2912: END IF;

Line 6705: FROM mtl_shipping_network_view MSNV,

6701: /****** Get FOB POINT ******/
6702: IF (l_xfer_organization_id IS NOT NULL) THEN
6703: IF l_transaction_action_id = 21 THEN /* Intransit Shipment */
6704: SELECT nvl(MMT.fob_point, MSNV.fob_point) INTO l_fob_point
6705: FROM mtl_shipping_network_view MSNV,
6706: mtl_material_transactions MMT
6707: WHERE MSNV.from_organization_id = l_organization_id
6708: AND MSNV.to_organization_id = l_xfer_organization_id
6709: AND MMT.transaction_id = p_transaction_id;

Line 6713: FROM mtl_shipping_network_view MSNV,

6709: AND MMT.transaction_id = p_transaction_id;
6710: ELSIF l_transaction_action_id = 12 THEN /* Intransit Receipt */
6711: SELECT nvl(MMT.fob_point, MSNV.fob_point)
6712: INTO l_fob_point
6713: FROM mtl_shipping_network_view MSNV,
6714: mtl_material_transactions MMT
6715: WHERE MSNV.from_organization_id = l_xfer_organization_id
6716: AND MSNV.to_organization_id = l_organization_id
6717: AND MMT.transaction_id = p_transaction_id;