APPS.EDW_ITEMS_M_C dependencies on MFG_LOOKUPS

Line 738: FROM mfg_lookups lkup

734:
735: UPDATE EDW_ITEM_ITEMORG_TEMP
736: SET MAKE_OR_BUY_FLAG =
737: (SELECT lkup.meaning
738: FROM mfg_lookups lkup
739: WHERE lkup.lookup_type = 'MTL_PLANNING_MAKE_BUY'
740: AND lkup.lookup_code = TO_NUMBER(make_or_buy_flag)),
741: LOCATOR_CONTROL =
742: (SELECT lkup.meaning

Line 743: FROM mfg_lookups lkup

739: WHERE lkup.lookup_type = 'MTL_PLANNING_MAKE_BUY'
740: AND lkup.lookup_code = TO_NUMBER(make_or_buy_flag)),
741: LOCATOR_CONTROL =
742: (SELECT lkup.meaning
743: FROM mfg_lookups lkup
744: WHERE lkup.lookup_type = 'MTL_LOCATION_CONTROL'
745: AND lkup.lookup_code = TO_NUMBER(locator_control)),
746: EFFECTIVITY_CONTROL =
747: (SELECT lkup.meaning

Line 748: FROM mfg_lookups lkup

744: WHERE lkup.lookup_type = 'MTL_LOCATION_CONTROL'
745: AND lkup.lookup_code = TO_NUMBER(locator_control)),
746: EFFECTIVITY_CONTROL =
747: (SELECT lkup.meaning
748: FROM mfg_lookups lkup
749: WHERE lkup.lookup_type = 'MTL_EFFECTIVITY_CONTROL'
750: AND lkup.lookup_code = TO_NUMBER(effectivity_control)),
751: LOT_CONTROL =
752: (SELECT lkup.meaning

Line 753: FROM mfg_lookups lkup

749: WHERE lkup.lookup_type = 'MTL_EFFECTIVITY_CONTROL'
750: AND lkup.lookup_code = TO_NUMBER(effectivity_control)),
751: LOT_CONTROL =
752: (SELECT lkup.meaning
753: FROM mfg_lookups lkup
754: WHERE lkup.lookup_type = 'MTL_LOT_CONTROL'
755: AND lkup.lookup_code = TO_NUMBER(lot_control)),
756: INV_PLANNING_CODE =
757: (SELECT lkup.meaning

Line 758: FROM mfg_lookups lkup

754: WHERE lkup.lookup_type = 'MTL_LOT_CONTROL'
755: AND lkup.lookup_code = TO_NUMBER(lot_control)),
756: INV_PLANNING_CODE =
757: (SELECT lkup.meaning
758: FROM mfg_lookups lkup
759: WHERE lkup.lookup_type = 'MTL_MATERIAL_PLANNING'
760: AND lkup.lookup_code = TO_NUMBER(inv_planning_code)),
761: MRP_PLN_METHOD =
762: (SELECT lkup.meaning

Line 763: FROM mfg_lookups lkup

759: WHERE lkup.lookup_type = 'MTL_MATERIAL_PLANNING'
760: AND lkup.lookup_code = TO_NUMBER(inv_planning_code)),
761: MRP_PLN_METHOD =
762: (SELECT lkup.meaning
763: FROM mfg_lookups lkup
764: WHERE lkup.lookup_type = 'MRP_PLANNING_CODE'
765: AND lkup.lookup_code = TO_NUMBER(mrp_pln_method)),
766: REVISION_CONTROL =
767: (SELECT lkup.meaning

Line 768: FROM mfg_lookups lkup

764: WHERE lkup.lookup_type = 'MRP_PLANNING_CODE'
765: AND lkup.lookup_code = TO_NUMBER(mrp_pln_method)),
766: REVISION_CONTROL =
767: (SELECT lkup.meaning
768: FROM mfg_lookups lkup
769: WHERE lkup.lookup_type = 'MTL_ENG_QUANTITY'
770: AND lkup.lookup_code = TO_NUMBER(revision_control)),
771: SHELF_LIFE_CODE =
772: (SELECT lkup.meaning

Line 773: FROM mfg_lookups lkup

769: WHERE lkup.lookup_type = 'MTL_ENG_QUANTITY'
770: AND lkup.lookup_code = TO_NUMBER(revision_control)),
771: SHELF_LIFE_CODE =
772: (SELECT lkup.meaning
773: FROM mfg_lookups lkup
774: WHERE lkup.lookup_type = 'MTL_SHELF_LIFE'
775: AND lkup.lookup_code = TO_NUMBER(shelf_life_code)),
776: SERIAL_CONTROL =
777: (SELECT lkup.meaning

Line 778: FROM mfg_lookups lkup

774: WHERE lkup.lookup_type = 'MTL_SHELF_LIFE'
775: AND lkup.lookup_code = TO_NUMBER(shelf_life_code)),
776: SERIAL_CONTROL =
777: (SELECT lkup.meaning
778: FROM mfg_lookups lkup
779: WHERE lkup.lookup_type = 'MTL_SERIAL_NUMBER'
780: AND lkup.lookup_code = TO_NUMBER(serial_control)),
781: CATSET_CATEGORY_FK_KEY = NULL,
782: PROD_FAMILY_FK_KEY = NULL,