DBA Data[Home] [Help]

APPS.MRP_REL_PLAN_PUB dependencies on MRP_SYSTEM_ITEMS

Line 214: mrp_system_items msi,

210: mr.implement_end_item_unit_number,
211: 2,
212: 1
213: FROM mtl_parameters param,
214: mrp_system_items msi,
215: mrp_recommendations mr,
216: mrp_plan_organizations_v orgs
217: WHERE param.organization_id = msi.organization_id
218: AND msi.inventory_item_id = mr.inventory_item_id

Line 315: mrp_system_items msi,

311: 1,
312: Decode(var_upd_req_date_rel,'Y',mr.implement_date,NULL)
313: FROM mtl_parameters param,
314: mrp_item_wip_entities w,
315: mrp_system_items msi,
316: mrp_recommendations mr,
317: mrp_plan_organizations_v orgs
318: WHERE param.organization_id = msi.organization_id
319: AND msi.inventory_item_id = mr.inventory_item_id

Line 390: mrp_system_items msi,

386: nvl(msrs.implement_demand_class,var_demand_class),
387: 2,
388: 1
389: FROM mtl_parameters param,
390: mrp_system_items msi,
391: mrp_sugg_rep_schedules msrs,
392: mrp_plan_organizations_v orgs
393: WHERE param.organization_id = msi.organization_id
394: AND msi.compile_designator = msrs.compile_designator

Line 466: SELECT /*+ INDEX(MSI MRP_SYSTEM_ITEMS_U1)*/ /*2448571*/

462: project_id,
463: task_id,
464: end_item_unit_number,
465: project_accounting_context)
466: SELECT /*+ INDEX(MSI MRP_SYSTEM_ITEMS_U1)*/ /*2448571*/
467: /* 1, Quantity based */
468: mr.last_updated_by,
469: SYSDATE,
470: mr.last_update_login,

Line 537: mrp_system_items msi,

533: mrp_project_parameters mpp,
534: org_organization_definitions ood,
535: mtl_parameters mp,
536: mtl_system_items mti,
537: mrp_system_items msi,
538: mrp_recommendations mr,
539: mrp_plan_organizations_v orgs
540: WHERE ccga.cost_group_id (+)= nvl(mpp.costing_group_id, -23453)
541: AND ccga.organization_id(+)= mpp.organization_id

Line 606: mrp_system_items msi,

602: arg_user_id
603: FROM
604: mtl_parameters mp,
605: mrp_item_purchase_orders mipo,
606: mrp_system_items msi,
607: mrp_recommendations mr,
608: mrp_plan_organizations_v orgs
609: WHERE mipo.transaction_id = mr.disposition_id
610: AND mipo.line_id IS NOT NULL

Line 666: mrp_system_items msi,

662: l_po_number
663: FROM
664: mtl_parameters mp,
665: mrp_item_purchase_orders mipo,
666: mrp_system_items msi,
667: mrp_recommendations mr,
668: mrp_plan_organizations_v orgs
669: WHERE mipo.transaction_id = mr.disposition_id
670: AND mipo.line_id IS NOT NULL