DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 856: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce

852: OPEN x_cost_group_lov FOR
853: SELECT UNIQUE ccg.cost_group
854: , ccg.cost_group_id
855: , ccg.description
856: FROM cst_cost_groups ccg, mtl_cycle_count_entries mcce
857: WHERE ccg.organization_id = p_organization_id
858: AND ccg.cost_group LIKE (p_cost_group)
859: AND ccg.cost_group_id = mcce.cost_group_id
860: AND mcce.cycle_count_header_id = p_cycle_count_header_id

Line 1610: FROM mtl_lot_numbers mln, mtl_cycle_count_entries mcce,

1606: SELECT UNIQUE mln.lot_number
1607: , mln.description
1608: , mln.expiration_date
1609: , mmst.status_code
1610: FROM mtl_lot_numbers mln, mtl_cycle_count_entries mcce,
1611: mtl_material_statuses_tl mmst
1612: WHERE mln.organization_id = p_organization_id
1613: AND mln.inventory_item_id = p_inventory_item_id
1614: AND mln.status_id = mmst.status_id (+)