APPS.MRP_EXCEPTIONS_SC_PK dependencies on MFG_LOOKUPS

Line 63: FROM mfg_lookups lu,

59: lu.meaning,
60: decode(lu.lookup_code, 6, 0, 7, 0, 8, 0, 9, 0, 10, 0, NULL),
61: p_plan_name,
62: orgs.organization_id
63: FROM mfg_lookups lu,
64: mrp_item_exceptions ex,
65: mrp_plan_organizations_v orgs
66: WHERE lu.lookup_type = 'MRP_EXCEPTION_CODE_TYPE'
67: AND lu.lookup_code <=10

Line 149: FROM mfg_lookups lu,

145: lu.meaning,
146: DECODE(lu.lookup_code, 6, 0, 7, 0, 8, 0, 9, 0, 10, 0, NULL),
147: P_PLAN_NAME,
148: orgs.organization_id
149: FROM mfg_lookups lu,
150: mrp_item_exceptions ex,
151: mrp_system_items sys,
152: mrp_plan_organizations_v orgs
153: WHERE lu.lookup_type = 'MRP_EXCEPTION_CODE_TYPE'