APPS.PO_THIRD_PARTY_STOCK_GRP dependencies on IC_WHSE_MST

Line 117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;

113:
114: l_purch_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
115: l_req_flag FINANCIALS_SYSTEM_PARAMS_ALL.REQ_ENCUMBRANCE_FLAG%TYPE;
116: l_sob_id FINANCIALS_SYSTEM_PARAMS_ALL.SET_OF_BOOKS_ID%TYPE;
117: l_whse_code IC_WHSE_MST.WHSE_CODE%TYPE;
118: l_OSP_flag MTL_SYSTEM_ITEMS.OUTSIDE_OPERATION_FLAG%TYPE;
119: l_bom MTL_SYSTEM_ITEMS.BOM_ITEM_TYPE%TYPE;
120: l_replenish MTL_SYSTEM_ITEMS.REPLENISH_TO_ORDER_FLAG%TYPE;
121: l_autoconfig MTL_SYSTEM_ITEMS.AUTO_CREATED_CONFIG_FLAG%TYPE;

Line 229: -- INVCONV IC_WHSE_MST imst

225: l_asset ,
226: l_transactable,
227: l_stockable
228: FROM MTL_SYSTEM_ITEMS msi
229: -- INVCONV IC_WHSE_MST imst
230: WHERE -- INVCONV msi.organization_id = imst.mtl_organization_id (+)
231: msi.inventory_item_id = p_inventory_item_id
232: AND msi.organization_id = p_inventory_org_id ;
233:

Line 466: -- INVCONV ic_whse_mst imst

462: hr_organization_information hoi ,
463: mtl_parameters mp ,
464: hr_organization_information hoi2 ,
465: mtl_system_items msi
466: -- INVCONV ic_whse_mst imst
467: where HOU.ORGANIZATION_ID = HOI.ORGANIZATION_ID
468: and HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
469: and HOI.ORG_INFORMATION_CONTEXT||'' ='Accounting Information'
470: and HOI.ORG_INFORMATION1 = TO_CHAR(GSOB.SET_OF_BOOKS_ID)