DBA Data[Home] [Help]

APPS.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on MTL_ITEM_CATEGORIES

Line 137: FROM mtl_item_categories mic

133: AND cp_date BETWEEN cm.eff_start_date AND cm.eff_end_date
134: AND cm.delete_mark = 0
135: AND cm.cost_category_id IN
136: ( SELECT category_id
137: FROM mtl_item_categories mic
138: WHERE mic.inventory_item_id = NVL(cp_inventory_item_id, mic.inventory_item_id)
139: AND mic.organization_id = NVL(cp_organization_id, mic.organization_id)
140: )
141: UNION