DBA Data[Home] [Help]

APPS.MRP_REL_PLAN_PUB dependencies on MRP_PLAN_ORGANIZATIONS_V

Line 216: mrp_plan_organizations_v orgs

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
219: AND msi.compile_designator = mr.compile_designator
220: AND msi.organization_id = mr.organization_id

Line 317: mrp_plan_organizations_v orgs

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
320: AND msi.compile_designator = mr.compile_designator
321: AND msi.organization_id = mr.organization_id

Line 392: mrp_plan_organizations_v orgs

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
395: AND msi.organization_id = msrs.organization_id
396: AND msi.inventory_item_id = msrs.inventory_item_id

Line 539: mrp_plan_organizations_v orgs

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
542: AND mpp.organization_id (+)= mr.organization_id
543: AND mpp.project_id (+)= nvl(mr.implement_project_id, -23453)

Line 608: mrp_plan_organizations_v orgs

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
611: AND mipo.compile_designator = mr.compile_designator
612: AND mipo.organization_id = mr.organization_id

Line 668: mrp_plan_organizations_v orgs

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
671: AND mipo.compile_designator = mr.compile_designator
672: AND mipo.organization_id = mr.organization_id

Line 839: from mrp_plan_organizations_v

835: implement_alternate_bom = NULL,
836: implement_alternate_routing = NULL
837: WHERE organization_id IN
838: (select planned_organization
839: from mrp_plan_organizations_v
840: where organization_id = arg_org_id
841: and compile_designator = arg_compile_desig
842: AND planned_organization = decode(arg_log_org_id,
843: arg_org_id, planned_organization,

Line 866: from mrp_plan_organizations_v

862: load_type = NULL,
863: status = 3 -- bug2797945
864: WHERE organization_id IN
865: (select planned_organization
866: from mrp_plan_organizations_v
867: where organization_id = arg_org_id
868: and compile_designator = arg_compile_desig
869: AND planned_organization = decode(arg_log_org_id,
870: arg_org_id, planned_organization,