DBA Data[Home] [Help]

APPS.GMO_DISP_CON_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 10: FROM PO_HAZARD_CLASSES PHC, MTL_SYSTEM_ITEMS_VL MSI

6: IS
7: l_phc_hazard_class_name VARCHAR2(40);
8: CURSOR C_GET_PHC_CLASS IS
9: SELECT PHC.HAZARD_CLASS
10: FROM PO_HAZARD_CLASSES PHC, MTL_SYSTEM_ITEMS_VL MSI
11: WHERE MSI.INVENTORY_ITEM_ID= P_INVENTORY_ITEM_ID
12: and MSI.ORGANIZATION_ID = P_ORGANIZATION_ID
13: and MSI.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
14: and SYSDATE < (NVL(PHC.INACTIVE_DATE,sysdate));

Line 103: MTL_SYSTEM_ITEMS_VL MSI,

99: FROM
100: GME_BATCH_HEADER GBH,
101: GME_MATERIAL_DETAILS GMDL,
102: MTL_RESERVATIONS RES,
103: MTL_SYSTEM_ITEMS_VL MSI,
104: gmo_dispense_config conf,
105: gmo_dispense_config_inst conf_inst,
106: FND_LOOKUPS flYesNo,
107: (SELECT GBSI.MATERIAL_DETAIL_ID, GBSI.BATCHSTEP_ID,

Line 277: MTL_SYSTEM_ITEMS_VL MSI,

273: )
274: from
275: GMO_MATERIAL_DISPENSES GMDL,
276: GME_BATCH_HEADER gbh ,
277: MTL_SYSTEM_ITEMS_VL MSI,
278: Gme_Material_details GMD,
279: fnd_lookups lkup,
280: (SELECT GBS.BATCHSTEP_ID,
281: GBS.BATCHSTEP_NO ,