DBA Data[Home] [Help]

APPS.INV_REPLENISH_COUNT_LOVS dependencies on MFG_LOOKUPS

Line 97: , mfg_lookups ml

93: , mrh.default_count_type_code
94: , ml.meaning default_count_type
95: FROM mtl_replenish_headers mrh
96: , mtl_secondary_inventories msi
97: , mfg_lookups ml
98: WHERE mrh.organization_id = p_organization_id
99: AND mrh.subinventory_code = NVL(p_subinventory, mrh.subinventory_code)
100: AND msi.secondary_inventory_name = mrh.subinventory_code
101: AND msi.organization_id = mrh.organization_id

Line 625: FROM mfg_lookups

621: OR (p_qty_tracked = 2 AND p_inventory_planning_level = 1 AND p_par_level IS NOT NULL)THEN
622: OPEN x_replenish_count_types_lov FOR
623: SELECT lookup_code
624: , meaning
625: FROM mfg_lookups
626: WHERE lookup_type = 'MTL_COUNT_TYPES'
627: AND lookup_code IN (1,2)
628: AND enabled_flag = 'Y'
629: AND meaning LIKE p_count_type

Line 637: FROM mfg_lookups

633: ELSE
634: OPEN x_replenish_count_types_lov FOR
635: SELECT lookup_code
636: , meaning
637: FROM mfg_lookups
638: WHERE lookup_type = 'MTL_COUNT_TYPES'
639: AND lookup_code = 2
640: AND enabled_flag = 'Y'
641: AND meaning LIKE p_count_type