APPS.MSC_REL_PLAN_PUB dependencies on MSC_BOMS

Line 6748: msc_boms mb

6744: msc_parameters param,
6745: msc_system_items msi,
6746: msc_process_effectivity mpe,
6747: msc_supplies s,
6748: msc_boms mb
6749: WHERE tp.sr_tp_id= msi.organization_id
6750: AND tp.sr_instance_id= msi.sr_instance_id
6751: AND tp.partner_type=3
6752: AND param.organization_id = msi.organization_id

Line 6760: -- Added outer join on msc_boms as per columns in MSC_BOMS_N1 index,

6756: AND msi.organization_id = s.organization_id
6757: AND msi.sr_instance_id = s.sr_instance_id
6758: AND mpe.plan_id(+)= s.plan_id
6759: AND mpe.process_sequence_id(+)= s.process_seq_id
6760: -- Added outer join on msc_boms as per columns in MSC_BOMS_N1 index,
6761: -- for biogen enhancement - part2
6762: AND mb.plan_id(+) = s.plan_id
6763: AND mb.organization_id(+) = s.organization_id
6764: AND mb.sr_instance_id(+) = s.sr_instance_id

Line 7398: msc_boms bom,

7394: msc_item_id_lid sr_item,
7395: msc_bom_components subcomp,
7396: msc_component_substitutes bsub,
7397: /* msc_bom_components bcomp, */
7398: msc_boms bom,
7399: msc_system_items icomp,
7400: msc_demands md,
7401: msc_parameters param,
7402: msc_system_items msi,

Line 8276: msc_boms mb

8272: msc_parameters param,
8273: msc_system_items msi,
8274: msc_supplies s,
8275: msc_plan_organizations_v orgs,
8276: msc_boms mb
8277: WHERE tp.sr_tp_id= msi.organization_id
8278: AND tp.sr_instance_id= msi.sr_instance_id
8279: AND tp.partner_type=3
8280: AND param.organization_id = msi.organization_id

Line 8290: -- Added outer join on msc_boms as per columns in MSC_BOMS_N1 index,

8286: AND s.release_errors is NULL
8287: AND s.organization_id = orgs.planned_organization
8288: AND s.sr_instance_id = orgs.sr_instance_id
8289: AND s.plan_id = orgs.plan_id
8290: -- Added outer join on msc_boms as per columns in MSC_BOMS_N1 index,
8291: -- for biogen enhancement - part2
8292: AND mb.plan_id(+) = s.plan_id
8293: AND mb.organization_id(+) = s.organization_id
8294: AND mb.sr_instance_id(+) = s.sr_instance_id