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_PLAN_PUB dependencies on MSC_DEMANDS

Line 2965: ' msc_demands d,' ||

2961: ' msc_trading_partners mp2,' ||
2962: ' msc_system_items msi, ' ||
2963: ' msc_system_items msi1,' ||
2964: ' msc_supplies s,' ||
2965: ' msc_demands d,' ||
2966: ' msc_plan_organizations_v orgs ' ||
2967: ' WHERE mpp.organization_id (+)= s.organization_id ' ||
2968: ' AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2969: ' AND mpp.plan_id (+)= s.plan_id ' ||

Line 3408: msc_demands d,

3404: FROM msc_supplies s,
3405: msc_supplies s1,
3406: msc_supplies s2,
3407: msc_system_items msi1,
3408: msc_demands d,
3409: msc_demands d1,
3410: msc_demands d2,
3411: MFG0 mfg,
3412: mfg0 mfg1

Line 3409: msc_demands d1,

3405: msc_supplies s1,
3406: msc_supplies s2,
3407: msc_system_items msi1,
3408: msc_demands d,
3409: msc_demands d1,
3410: msc_demands d2,
3411: MFG0 mfg,
3412: mfg0 mfg1
3413: WHERE s.release_errors IS NULL

Line 3410: msc_demands d2,

3406: msc_supplies s2,
3407: msc_system_items msi1,
3408: msc_demands d,
3409: msc_demands d1,
3410: msc_demands d2,
3411: MFG0 mfg,
3412: mfg0 mfg1
3413: WHERE s.release_errors IS NULL
3414: AND s.sr_instance_id = '||p_arg_org_instance||

Line 4005: msc_demands d ,

4001: msc_system_items msi,
4002: msc_system_items msi1,
4003: msc_trading_partners mtp,
4004: msc_trading_partners mtp1,
4005: msc_demands d ,
4006: msc_demands d1,
4007: msc_demands d2,
4008: ( select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
4009: from msc_full_pegging

Line 4006: msc_demands d1,

4002: msc_system_items msi1,
4003: msc_trading_partners mtp,
4004: msc_trading_partners mtp1,
4005: msc_demands d ,
4006: msc_demands d1,
4007: msc_demands d2,
4008: ( select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
4009: from msc_full_pegging
4010: where sr_instance_id = '||p_arg_org_instance||'

Line 4007: msc_demands d2,

4003: msc_trading_partners mtp,
4004: msc_trading_partners mtp1,
4005: msc_demands d ,
4006: msc_demands d1,
4007: msc_demands d2,
4008: ( select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
4009: from msc_full_pegging
4010: where sr_instance_id = '||p_arg_org_instance||'
4011: and plan_id ='||p_arg_plan_id||'

Line 4922: msc_demands md,

4918: md.USING_REQUIREMENT_QUANTITY,
4919: 3,
4920: s.sr_instance_id
4921: From msc_supplies s,
4922: msc_demands md,
4923: msc_system_items icomp,
4924: msc_system_items icomp1,
4925: msc_system_items icomp2,
4926: msc_apps_instances ins,

Line 5869: msc_demands md,

5865: md.USING_REQUIREMENT_QUANTITY,
5866: 3,
5867: s.sr_instance_id
5868: From msc_supplies s,
5869: msc_demands md,
5870: msc_system_items icomp,
5871: msc_system_items icomp1,
5872: msc_system_items icomp2,
5873: msc_apps_instances ins,

Line 7170: msc_demands md,

7166: nvl(s.implement_uom_code,msi.uom_code),
7167: s.sr_instance_id
7168: FROM msc_trading_partners tp,
7169: msc_system_items icomp,
7170: msc_demands md,
7171: msc_parameters param,
7172: msc_system_items msi,
7173: msc_supplies s
7174: WHERE /*

Line 7400: msc_demands md,

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,
7403: msc_supplies s
7404: WHERE tp.sr_tp_id= msi.organization_id

Line 8690: msc_demands md,

8686: s.disposition_id
8687: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8688: FROM msc_trading_partners tp,
8689: msc_system_items icomp,
8690: msc_demands md,
8691: msc_parameters param,
8692: msc_system_items msi,
8693: msc_supplies s
8694: WHERE /*

Line 11417: msc_demands md,

11413: s.disposition_id
11414: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11415: FROM msc_trading_partners tp,
11416: msc_system_items icomp,
11417: msc_demands md,
11418: msc_parameters param,
11419: msc_system_items msi,
11420: msc_supplies s
11421: WHERE /*

Line 12747: msc_demands md,

12743: s.disposition_id
12744: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12745: FROM msc_trading_partners tp,
12746: msc_system_items icomp,
12747: msc_demands md,
12748: msc_parameters param,
12749: msc_system_items msi,
12750: msc_supplies s
12751: WHERE /*

Line 13431: msc_demands md,

13427: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
13428: FROM msc_trading_partners tp,
13429: msc_system_items icompold,
13430: msc_system_items icompnew,
13431: msc_demands md,
13432: msc_parameters param,
13433: msc_system_items msi,
13434: msc_supplies ms,
13435: msc_exception_details med