APPS.MSC_REL_PS_PLAN_PUB dependencies on MSC_ITEM_ID_LID

Line 1061: msc_item_id_lid item_lid,

1057: s.schedule_priority,
1058: nvl(s.requested_completion_date, s.need_by_date)
1059: FROM msc_trading_partners tp,
1060: msc_parameters param,
1061: msc_item_id_lid item_lid,
1062: msc_supplies s
1063: WHERE tp.sr_tp_id= s.organization_id
1064: AND tp.sr_instance_id= s.sr_instance_id
1065: AND tp.partner_type=3

Line 1918: msc_item_id_lid item_lid,

1914: s.schedule_priority,
1915: s.requested_completion_date
1916: FROM msc_trading_partners tp,
1917: msc_parameters param,
1918: msc_item_id_lid item_lid,
1919:
1920: msc_supplies s,
1921: msc_plan_organizations_v orgs
1922: WHERE tp.sr_tp_id= s.organization_id

Line 2857: msc_item_id_lid item_lid,

2853: s.schedule_priority,
2854: nvl(s.requested_completion_date, s.need_by_date)
2855: FROM msc_trading_partners tp,
2856: msc_parameters param,
2857: msc_item_id_lid item_lid,
2858: msc_supplies s
2859: WHERE tp.sr_tp_id= s.organization_id
2860: AND tp.sr_instance_id= s.sr_instance_id
2861: AND tp.partner_type=3

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

3192: -- bugbug Should we check sys_items for uom_code?
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

Line 3285: msc_item_id_lid icomp,

3281: TO_CHAR(NULL),
3282: s.implement_uom_code, -- bugbug MN: again is this correct?
3283: s.sr_instance_id
3284: FROM msc_trading_partners tp,
3285: msc_item_id_lid icomp,
3286: msc_supplies co,
3287: msc_parameters param,
3288: msc_supplies s
3289: WHERE tp.sr_tp_id = s.organization_id

Line 3374: msc_item_id_lid sr_item,

3370: -- md.operation_seq_id,
3371: s.implement_uom_code, -- bugbug again should fall back to sys_items?
3372: s.sr_instance_id
3373: FROM msc_trading_partners tp,
3374: msc_item_id_lid sr_item,
3375: msc_bom_components subcomp,
3376: msc_component_substitutes bsub,
3377: /* msc_bom_components bcomp, */
3378: msc_item_id_lid icomp,

Line 3378: msc_item_id_lid icomp,

3374: msc_item_id_lid sr_item,
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

Line 3947: msc_item_id_lid item_lid,

3943: s.requested_completion_date -- dsr
3944: FROM msc_trading_partners tp,
3945: msc_parameters param,
3946: msc_supplies s,
3947: msc_item_id_lid item_lid,
3948: msc_plan_organizations_v orgs
3949: WHERE tp.sr_tp_id= s.organization_id --MN: again, is this correct ? -- ey, should be s.organization_id -- MN: done
3950: AND item_lid.sr_instance_id = s.sr_instance_id --MN:: added
3951: AND item_lid.inventory_item_id = s.inventory_item_id

Line 4384: msc_item_id_lid icomp,

4380: s.disposition_id
4381: FROM msc_trading_partners tp,
4382: msc_supplies co,
4383: msc_parameters param,
4384: msc_item_id_lid icomp,
4385: msc_supplies s
4386: WHERE tp.sr_tp_id = s.organization_id
4387: --MN: again, is this correct? -- ey, correct
4388: AND tp.sr_instance_id = s.sr_instance_id --MN: again, is this correct? -- ey, correct

Line 4472: msc_item_id_lid sr_item,

4468: -- md.operation_seq_id,
4469: s.implement_uom_code, -- bugbug again should fall back to sys_items?
4470: s.sr_instance_id
4471: FROM msc_trading_partners tp,
4472: msc_item_id_lid sr_item,
4473: msc_bom_components subcomp,
4474: msc_component_substitutes bsub,
4475: /* msc_bom_components bcomp, */
4476: msc_item_id_lid icomp,

Line 4476: msc_item_id_lid icomp,

4472: msc_item_id_lid sr_item,
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