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 523: FROM mfg_lookups

519: OR (p_qty_tracked = 2 AND p_inventory_planning_level = 1 AND p_par_level IS NOT NULL)THEN
520: OPEN x_replenish_count_types_lov FOR
521: SELECT lookup_code
522: , meaning
523: FROM mfg_lookups
524: WHERE lookup_type = 'MTL_COUNT_TYPES'
525: AND lookup_code IN (1,2)
526: AND enabled_flag = 'Y'
527: AND meaning LIKE p_count_type

Line 535: FROM mfg_lookups

531: ELSE
532: OPEN x_replenish_count_types_lov FOR
533: SELECT lookup_code
534: , meaning
535: FROM mfg_lookups
536: WHERE lookup_type = 'MTL_COUNT_TYPES'
537: AND lookup_code = 2
538: AND enabled_flag = 'Y'
539: AND meaning LIKE p_count_type