DBA Data[Home] [Help]

APPS.CST_INVENTORY_PVT dependencies on MTL_ITEM_CATEGORIES

Line 131: FROM mtl_item_categories MIC,

127: )
128: SELECT MSI.inventory_item_id,
129: MIC.category_id,
130: CIC.cost_type_id
131: FROM mtl_item_categories MIC,
132: mtl_system_items_kfv MSI,
133: cst_item_costs CIC
134: -- cst_item_costs CIC1,
135: -- cst_item_costs CIC2

Line 173: FROM mtl_item_categories MIC,

169: )
170: SELECT MSI.inventory_item_id,
171: MIC.category_id,
172: CIC.cost_type_id
173: FROM mtl_item_categories MIC,
174: mtl_system_items_kfv MSI,
175: cst_item_costs CIC,
176: cst_item_costs CIC1,
177: cst_item_costs CIC2

Line 222: FROM mtl_item_categories MIC,

218: )
219: SELECT MSI.inventory_item_id,
220: MIC.category_id,
221: CIC.cost_type_id
222: FROM mtl_item_categories MIC,
223: mtl_categories_kfv MC,
224: mtl_system_items_kfv MSI,
225: cst_item_costs CIC
226: -- cst_item_costs CIC1,

Line 273: FROM mtl_item_categories MIC,

269: )
270: SELECT MSI.inventory_item_id,
271: MIC.category_id,
272: CIC.cost_type_id
273: FROM mtl_item_categories MIC,
274: mtl_categories_kfv MC,
275: mtl_system_items_kfv MSI,
276: cst_item_costs CIC,
277: cst_item_costs CIC1,

Line 336: FROM mtl_item_categories MIC,

332: )
333: SELECT MSI.inventory_item_id,
334: MIC.category_id,
335: l_def_cost_type_id
336: FROM mtl_item_categories MIC,
337: mtl_categories_kfv MC,
338: mtl_system_items_kfv MSI
339: WHERE MC.concatenated_segments
340: BETWEEN NVL(p_category_from,MC.concatenated_segments)