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_ITEM_ID_LID

Line 1087: msc_item_id_lid item_lid,

1083: s.schedule_priority,
1084: nvl(s.requested_completion_date, s.need_by_date)
1085: FROM msc_trading_partners tp,
1086: msc_parameters param,
1087: msc_item_id_lid item_lid,
1088: msc_supplies s
1089: WHERE tp.sr_tp_id= s.organization_id
1090: AND tp.sr_instance_id= s.sr_instance_id
1091: AND tp.partner_type=3

Line 1945: msc_item_id_lid item_lid,

1941: s.schedule_priority,
1942: s.requested_completion_date
1943: FROM msc_trading_partners tp,
1944: msc_parameters param,
1945: msc_item_id_lid item_lid,
1946:
1947: msc_supplies s,
1948: msc_plan_organizations_v orgs
1949: WHERE tp.sr_tp_id= s.organization_id

Line 2884: msc_item_id_lid item_lid,

2880: s.schedule_priority,
2881: nvl(s.requested_completion_date, s.need_by_date)
2882: FROM msc_trading_partners tp,
2883: msc_parameters param,
2884: msc_item_id_lid item_lid,
2885: msc_supplies s
2886: WHERE tp.sr_tp_id= s.organization_id
2887: AND tp.sr_instance_id= s.sr_instance_id
2888: AND tp.partner_type=3

Line 3223: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?

3219: -- bugbug Should we check sys_items for uom_code?
3220: s.implement_uom_code,
3221: s.sr_instance_id
3222: FROM msc_trading_partners tp,
3223: msc_system_items icomp, -- bugbug ey, should this be msc_item_id_lid or msi?
3224: msc_demands md,
3225: msc_parameters param,
3226: msc_supplies s
3227: WHERE

Line 3312: msc_item_id_lid icomp,

3308: TO_CHAR(NULL),
3309: s.implement_uom_code, -- bugbug MN: again is this correct?
3310: s.sr_instance_id
3311: FROM msc_trading_partners tp,
3312: msc_item_id_lid icomp,
3313: msc_supplies co,
3314: msc_parameters param,
3315: msc_supplies s
3316: WHERE tp.sr_tp_id = s.organization_id

Line 3401: msc_item_id_lid sr_item,

3397: -- md.operation_seq_id,
3398: s.implement_uom_code, -- bugbug again should fall back to sys_items?
3399: s.sr_instance_id
3400: FROM msc_trading_partners tp,
3401: msc_item_id_lid sr_item,
3402: msc_bom_components subcomp,
3403: msc_component_substitutes bsub,
3404: /* msc_bom_components bcomp, */
3405: msc_item_id_lid icomp,

Line 3405: msc_item_id_lid icomp,

3401: msc_item_id_lid sr_item,
3402: msc_bom_components subcomp,
3403: msc_component_substitutes bsub,
3404: /* msc_bom_components bcomp, */
3405: msc_item_id_lid icomp,
3406: msc_demands md,
3407: msc_supplies s
3408:
3409: WHERE tp.sr_tp_id= s.organization_id

Line 3975: msc_item_id_lid item_lid,

3971: s.requested_completion_date -- dsr
3972: FROM msc_trading_partners tp,
3973: msc_parameters param,
3974: msc_supplies s,
3975: msc_item_id_lid item_lid,
3976: msc_plan_organizations_v orgs,
3977: msc_demands md
3978: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
3979: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added

Line 4115: msc_item_id_lid item_lid,

4111: s.requested_completion_date -- dsr
4112: FROM msc_trading_partners tp,
4113: msc_parameters param,
4114: msc_supplies s,
4115: msc_item_id_lid item_lid,
4116: msc_plan_organizations_v orgs
4117: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
4118: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
4119: AND item_lid.inventory_item_id = s.inventory_item_id

Line 4252: msc_item_id_lid item_lid,

4248: s.requested_completion_date -- dsr
4249: FROM msc_trading_partners tp,
4250: msc_parameters param,
4251: msc_supplies s,
4252: msc_item_id_lid item_lid,
4253: msc_plan_organizations_v orgs
4254: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
4255: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
4256: AND item_lid.inventory_item_id = s.inventory_item_id

Line 4689: msc_item_id_lid icomp,

4685: s.disposition_id
4686: FROM msc_trading_partners tp,
4687: msc_supplies co,
4688: msc_parameters param,
4689: msc_item_id_lid icomp,
4690: msc_supplies s
4691: WHERE tp.sr_tp_id = s.organization_id
4692: --MN: again, is this correct? -- ey, correct
4693: AND tp.sr_instance_id = s.sr_instance_id --MN: again, is this correct? -- ey, correct

Line 4779: msc_item_id_lid sr_item,

4775: -- md.operation_seq_id,
4776: s.implement_uom_code, -- bugbug again should fall back to sys_items?
4777: s.sr_instance_id
4778: FROM msc_trading_partners tp,
4779: msc_item_id_lid sr_item,
4780: msc_bom_components subcomp,
4781: msc_component_substitutes bsub,
4782: /* msc_bom_components bcomp, */
4783: msc_item_id_lid icomp,

Line 4783: msc_item_id_lid icomp,

4779: msc_item_id_lid sr_item,
4780: msc_bom_components subcomp,
4781: msc_component_substitutes bsub,
4782: /* msc_bom_components bcomp, */
4783: msc_item_id_lid icomp,
4784: msc_demands md,
4785: msc_supplies s
4786:
4787: WHERE tp.sr_tp_id= s.organization_id