eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_DEMANDS

Line 1392: msc_demands md,

1388: md.USING_REQUIREMENT_QUANTITY,
1389: 3,
1390: s.sr_instance_id
1391: From msc_supplies s,
1392: msc_demands md,
1393: msc_system_items icomp,
1394: msc_system_items icomp1,
1395: msc_system_items icomp2,
1396: msc_apps_instances ins,

Line 2271: msc_demands md,

2267: md.USING_REQUIREMENT_QUANTITY,
2268: 3,
2269: s.sr_instance_id
2270: From msc_supplies s,
2271: msc_demands md,
2272: msc_system_items icomp,
2273: msc_system_items icomp1,
2274: msc_system_items icomp2,
2275: msc_apps_instances ins,

Line 3197: msc_demands md,

3193: s.implement_uom_code,
3194: s.sr_instance_id
3195: FROM msc_trading_partners tp,
3196: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3197: msc_demands md,
3198: msc_parameters param,
3199: msc_supplies s
3200: WHERE
3201: tp.sr_tp_id= icomp.organization_id

Line 3379: msc_demands md,

3375: msc_bom_components subcomp,
3376: msc_component_substitutes bsub,
3377: /* msc_bom_components bcomp, */
3378: msc_item_id_lid icomp,
3379: msc_demands md,
3380: msc_supplies s
3381:
3382: WHERE tp.sr_tp_id= s.organization_id
3383: AND tp.sr_instance_id= s.sr_instance_id

Line 4254: msi.sr_inventory_item_id, -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands

4250: s.organization_id,
4251: arg_wip_group_id,
4252: s.transaction_id,
4253: nvl(md.op_seq_num,1),
4254: msi.sr_inventory_item_id, -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4255: decode(l_apps_ver,'3',null,msi.sr_inventory_item_id),
4256: -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4257: decode(md.component_scaling_type,1,NULL,md.component_scaling_type),
4258: decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),(md.USING_REQUIREMENT_QUANTITY/s.implement_quantity)),

Line 4256: -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands

4252: s.transaction_id,
4253: nvl(md.op_seq_num,1),
4254: msi.sr_inventory_item_id, -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4255: decode(l_apps_ver,'3',null,msi.sr_inventory_item_id),
4256: -- bugbug MN: again, is this correct? -- ey, no, this should be the source item id for the item in msc_demands
4257: decode(md.component_scaling_type,1,NULL,md.component_scaling_type),
4258: decode(l_apps_ver,'4',TO_NUMBER(NULL),'3',TO_NUMBER(NULL),(md.USING_REQUIREMENT_QUANTITY/s.implement_quantity)),
4259: md.component_yield_factor, -- bugbug is this correct?
4260: TO_NUMBER(NULL), --Department_ID

Line 4282: msc_demands md,

4278: -- md.operation_seq_id,
4279: s.implement_uom_code, -- bugbug MN: again, is this correct?
4280: s.disposition_id
4281: FROM msc_trading_partners tp,
4282: msc_demands md,
4283: msc_parameters param,
4284: msc_system_items msi,
4285: msc_supplies s
4286: -- bugbug Is this join correct?

Line 4291: --MN: again, is this correct? -- /* ey, no, this link should be removed, the original link is to find the source item_id for the item in msc_demands */

4287: WHERE tp.sr_tp_id= msi.organization_id -- ey, should be s.organization_id
4288: AND tp.sr_instance_id= s.sr_instance_id -- ey, s.sr_instance_id
4289: AND tp.partner_type=3
4290: AND s.inventory_item_id= md.inventory_item_id
4291: --MN: again, is this correct? -- /* ey, no, this link should be removed, the original link is to find the source item_id for the item in msc_demands */
4292: AND s.organization_id= md.organization_id --MN: again, is this correct? -- ey, no, this link should be
4293: AND s.sr_instance_id= md.sr_instance_id --MN: again, is this correct? -- ey, no, this link should be
4294: AND nvl(md.wip_supply_type,0) <> 6 -- ey, you need to find the wip_supply_type for the item_id in msc_demands
4295: AND md.PRIMARY_COMPONENT_ID is null

Line 4294: AND nvl(md.wip_supply_type,0) <> 6 -- ey, you need to find the wip_supply_type for the item_id in msc_demands

4290: AND s.inventory_item_id= md.inventory_item_id
4291: --MN: again, is this correct? -- /* ey, no, this link should be removed, the original link is to find the source item_id for the item in msc_demands */
4292: AND s.organization_id= md.organization_id --MN: again, is this correct? -- ey, no, this link should be
4293: AND s.sr_instance_id= md.sr_instance_id --MN: again, is this correct? -- ey, no, this link should be
4294: AND nvl(md.wip_supply_type,0) <> 6 -- ey, you need to find the wip_supply_type for the item_id in msc_demands
4295: AND md.PRIMARY_COMPONENT_ID is null
4296: AND md.sr_instance_id= s.sr_instance_id
4297: AND md.disposition_id= s.transaction_id
4298: AND md.plan_id= s.plan_id

Line 4477: msc_demands md,

4473: msc_bom_components subcomp,
4474: msc_component_substitutes bsub,
4475: /* msc_bom_components bcomp, */
4476: msc_item_id_lid icomp,
4477: msc_demands md,
4478: msc_supplies s
4479:
4480: WHERE tp.sr_tp_id= s.organization_id
4481: AND tp.sr_instance_id= s.sr_instance_id