DBA Data[Home] [Help]

APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 103: ,mtl_system_items_kfv ITEM

99: ,SPEC.SPEC_TYPE
100: ,SPEC.OVERLAY_IND
101: ,SPEC.BASE_SPEC_ID
102: FROM GMD_SPECIFICATIONS SPEC
103: ,mtl_system_items_kfv ITEM
104: ,mtl_parameters ORGN
105: ,GMD_QC_STATUS QCSTAT
106: ,MTL_ORGANIZATIONS MO
107: WHERE SPEC.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID (+)

Line 135: ,mtl_system_items_kfv ITEM

131: ,SPEC.OVERLAY_IND
132: ,SPEC.BASE_SPEC_ID
133: FROM
134: GMD_SPECIFICATIONS SPEC
135: ,mtl_system_items_kfv ITEM
136: ,mtl_parameters ORGN
137: ,GMD_QC_STATUS QCSTAT
138: --,MTL_ORGANIZATIONS MO
139: ,HR_ALL_ORGANIZATION_UNITS_TL HR -- sql id