APPS.GMF_LOT_COSTING_PUB dependencies on MTL_ITEM_CATEGORIES

Line 1553: FROM mtl_item_categories mic,

1549: AND p_date BETWEEN eff_start_date AND eff_end_date
1550: AND delete_mark = 0
1551: AND cost_category_id IN
1552: ( SELECT category_id -- cost_category_id Bug#7306720
1553: FROM mtl_item_categories mic,
1554: gmf_process_organizations_gt gpo
1555: WHERE mic.inventory_item_id = p_item_id
1556: AND mic.organization_id = gpo.organization_id
1557: AND (mic.organization_id = p_orgn_id OR p_orgn_id IS NULL)

Line 1760: FROM mtl_item_categories mic,

1756: AND msi.inventory_item_id = p_item_id
1757: AND msi.organization_id = p_orgn_id
1758: UNION
1759: SELECT msi.inventory_item_id
1760: FROM mtl_item_categories mic,
1761: gmf_lot_costed_items g,
1762: mtl_system_items_b msi
1763: WHERE g.cost_category_id = mic.category_id
1764: AND g.legal_entity_id = l_le_id

Line 1857: FROM mtl_item_categories mic,

1853: SELECT
1854: mic.organization_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
1855: mic.inventory_item_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
1856: i.primary_uom_code
1857: FROM mtl_item_categories mic,
1858: gmf_lot_costed_items g,
1859: mtl_system_items_b i,
1860: gmf_process_organizations_gt gpo
1861: WHERE g.cost_category_id = mic.category_id

Line 8940: FROM mtl_item_categories mic,

8936: SELECT
8937: i.organization_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
8938: i.inventory_item_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
8939: i.primary_uom_code
8940: FROM mtl_item_categories mic,
8941: mtl_default_category_sets mdc,
8942: mtl_category_sets mcs,
8943: gmf_lot_costed_items g,
8944: mtl_system_items_b i,

Line 8990: FROM mtl_item_categories mic,

8986: SELECT
8987: mic.organization_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
8988: mic.inventory_item_id, /*ANTHIYAG Bug#5279681 06-Jun-2006 */
8989: i.primary_uom_code
8990: FROM mtl_item_categories mic,
8991: mtl_default_category_sets mdc,
8992: mtl_category_sets mcs,
8993: gmf_lot_costed_items g,
8994: mtl_system_items_b i,