DBA Data[Home] [Help]

APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on MFG_LOOKUPS

Line 593: mfg_lookups mfg,

589: set implement_as =
590: (select
591: mfg.lookup_code
592: from
593: mfg_lookups mfg,
594: mrp_system_items msi
595: where mfg.lookup_code =
596: DECODE(mr.source_organization_id,
597: mr.organization_id,

Line 619: from mfg_lookups mfg,

615: update mrp_recommendations mr
616: set implement_as =
617: (select
618: mfg.lookup_code
619: from mfg_lookups mfg,
620: mrp_system_items msi
621: where mfg.lookup_code =
622: DECODE(msi.planning_make_buy_code,
623: 1, DECODE(msi.build_in_wip_flag, 1, 3, 1),