DBA Data[Home] [Help]

APPS.GMDQSPEC_APPROVAL_WF_PKG dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 139: ,HR_ALL_ORGANIZATION_UNITS_TL HR -- sql id

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
140: WHERE SPEC.INVENTORY_ITEM_ID = ITEM.INVENTORY_ITEM_ID (+)
141: AND ORGN.ORGANIZATION_ID = SPEC.OWNER_ORGANIZATION_ID
142: and ORGN.ORGANIZATION_ID = HR.ORGANIZATION_ID -- sql id
143: and hr.language = userenv('LANG') -- sql id