APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on MRP_SYSTEM_ITEMS

Line 210: from mrp_system_items msi

206: query_id = g_rec_query_id)
207: and (inventory_item_id, organization_id) IN
208: (select inventory_item_id,
209: organization_id
210: from mrp_system_items msi
211: where msi.compile_designator = mr.compile_designator
212: AND msi.bom_item_type in (1, 2, 3, 5));
213: --Bug3294041 Do not let user release Action=none records.
214: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ACTION_NONE');

Line 224: from mrp_system_items msi

220: query_id = g_rec_query_id)
221: and (((inventory_item_id, organization_id) IN
222: (select inventory_item_id,
223: organization_id
224: from mrp_system_items msi
225: where msi.compile_designator = mr.compile_designator
226: AND msi.base_item_id is not null
227: and release_configs = 'N')) OR
228: ( mr.rescheduled_flag =1) OR

Line 255: from mrp_system_items msi,

251: query_id = g_rec_query_id)
252: and (inventory_item_id, organization_id) IN
253: (select flex.inventory_item_id,
254: flex.organization_id
255: from mrp_system_items msi,
256: mtl_item_flexfields flex
257: where msi.compile_designator = mr.compile_designator
258: and flex.inventory_item_id = msi.inventory_item_id
259: and flex.organization_id = msi.organization_id

Line 293: from mrp_system_items msi

289: where
290: query_id = g_rec_query_id)
291: and (inventory_item_id, organization_id) IN
292: (select inventory_item_id, organization_id
293: from mrp_system_items msi
294: where msi.compile_designator = mr.compile_designator
295: and msi.inventory_item_id = mr.inventory_item_id
296: and msi.organization_id = mr.organization_id
297: and msi.in_source_plan = 1);

Line 350: from mrp_system_items msi

346: query_id = g_rep_query_id)
347: and (inventory_item_id, organization_id) IN
348: (select inventory_item_id,
349: organization_id
350: from mrp_system_items msi
351: where msi.compile_designator = msrs.compile_designator
352: AND msi.bom_item_type in (1, 2, 3, 5));
353:
354:

Line 388: from mrp_system_items msi

384: where
385: query_id = g_rep_query_id)
386: and (inventory_item_id, organization_id) IN
387: (select inventory_item_id, organization_id
388: from mrp_system_items msi
389: where msi.compile_designator = msrs.compile_designator
390: and msi.inventory_item_id = msrs.inventory_item_id
391: and msi.organization_id = msrs.organization_id
392: and msi.in_source_plan = 1);

Line 594: mrp_system_items msi

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,
598: DECODE(msi.build_in_wip_flag, 1, 3, 1),

Line 620: mrp_system_items msi

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),
624: DECODE(msi.purchasing_enabled_flag, 1, 2, 1))

Line 667: from mrp_system_items msi

663: and release_errors is null
664: and order_type =5
665: and (inventory_item_id, organization_id) in
666: (select inventory_item_id, organization_id
667: from mrp_system_items msi
668: where msi.compile_designator=mr.compile_designator
669: and msi.effectivity_control=2);
670: /*--------------------------------------------------------------+
671: | add error message if implement_unit_number is null |

Line 684: from mrp_system_items msi

680: where query_id=g_rec_query_id)
681: and implement_end_item_unit_number is null
682: and (inventory_item_id, organization_id) in
683: (select inventory_item_id, organization_id
684: from mrp_system_items msi
685: where msi.compile_designator=mr.compile_designator
686: and msi.effectivity_control=2);
687:
688: /*--------------------------------------------------------------+