APPS.AHL_MM_MTL_MGT_PVT dependencies on MTL_SHIPPING_NETWORK_VIEW

Line 2179: FROM MTL_SHIPPING_NETWORK_VIEW

2175: -- Get the shipping network information and internal order enabled flag value
2176: BEGIN
2177: SELECT INTRANSIT_TYPE, INTERNAL_ORDER_REQUIRED_FLAG
2178: INTO L_SHIPPING_NETWORK_CODE, L_ISO_REQ_FLAG
2179: FROM MTL_SHIPPING_NETWORK_VIEW
2180: WHERE FROM_ORGANIZATION_ID = P_SOURCE_ORG
2181: AND TO_ORGANIZATION_ID = L_DEMAND_ORG_ID;
2182: EXCEPTION
2183: WHEN NO_DATA_FOUND THEN

Line 4102: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;

4098: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_MM_MTL_MGT_PVT.Perform_Inter_Org_Transfer';
4099: l_msg_index_out NUMBER;
4100:
4101: -- Local Variables
4102: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;
4103:
4104: -- Record type variables
4105: -- Variables for making reservation
4106: l_rsv_rec AHL_MM_RESERVATIONS_PVT.mtl_reservation_rec_type;

Line 4206: FROM MTL_SHIPPING_NETWORK_VIEW

4202: G_DEBUG_LINE_NUM := 40;
4203: -- Get the shipping org type
4204: SELECT intransit_type
4205: INTO l_shipping_network_code
4206: FROM MTL_SHIPPING_NETWORK_VIEW
4207: WHERE from_organization_id =p_x_mtltfr_tbl(i).source_org_id
4208: AND to_organization_id = p_x_mtltfr_tbl(i).dest_org_id ;
4209:
4210: IF (l_shipping_network_code = C_DIRECT_NETWORK)

Line 4444: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;

4440: l_error_code VARCHAR2(240);
4441:
4442: l_item mtl_system_items_kfv.concatenated_segments%TYPE;
4443: l_serial MTL_SERIAL_NUMBERS_INTERFACE.FM_SERIAL_NUMBER%TYPE;
4444: l_shipping_network_code MTL_SHIPPING_NETWORK_VIEW.intransit_type%TYPE;
4445:
4446: -- Record Type variables
4447: l_x_mtltfr_rec Ahl_Mtltfr_Rec_Type; -- record type variable for storing each item record
4448: l_transaction_id_tbl transaction_intf_tbl; -- stores the transaction ids for each record

Line 4584: FROM MTL_SHIPPING_NETWORK_VIEW

4580:
4581: -- Get the shipping org type
4582: SELECT intransit_type
4583: INTO l_shipping_network_code
4584: FROM MTL_SHIPPING_NETWORK_VIEW
4585: WHERE from_organization_id =p_x_mtltfr_tbl(i).source_org_id
4586: AND to_organization_id = p_x_mtltfr_tbl(i).dest_org_id ;
4587:
4588: --log

Line 5200: FROM MTL_SHIPPING_NETWORK_VIEW

5196: -- Shipping Network validation
5197: CURSOR SHIPPING_NETWORK_CUR(p_source_org_id NUMBER, p_dest_org_id NUMBER)
5198: IS
5199: SELECT 1
5200: FROM MTL_SHIPPING_NETWORK_VIEW
5201: WHERE from_organization_id =p_source_org_id
5202: AND to_organization_id = p_dest_org_id ;
5203:
5204: -- Shiipinmg allowed validation

Line 5208: FROM MTL_SHIPPING_NETWORK_VIEW

5204: -- Shiipinmg allowed validation
5205: CURSOR SHIPPING_ATTRIB_CUR(p_source_org_id NUMBER, p_dest_org_id NUMBER)
5206: IS
5207: SELECT 1
5208: FROM MTL_SHIPPING_NETWORK_VIEW
5209: WHERE from_organization_id =p_source_org_id
5210: AND to_organization_id = p_dest_org_id
5211: AND internal_order_required_flag = 1;
5212: