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_TRADING_PARTNERS

Line 278: and for the OPM orgs organization_type = 2 in msc_trading_partners */

274:
275: lv_yield_dis := 0;
276:
277: /* For bug: 2559388 - added this If cond to return RCY=1 (for OPM, there is no RCY concept ,so return 1
278: and for the OPM orgs organization_type = 2 in msc_trading_partners */
279:
280: IF (org_type = 2) THEN
281: lv_yield_dis := 1;
282: RETURN lv_yield_dis;

Line 340: and for the OPM orgs organization_type = 2 in msc_trading_partners */

336:
337: lv_yield_dis := 0;
338:
339: /* For bug: 2559388 - added this If cond to return RCY=1 (for OPM, there is no RCY concept ,so return 1
340: and for the OPM orgs organization_type = 2 in msc_trading_partners */
341:
342: IF (org_type = 2) THEN
343: lv_yield_dis := 1;
344: RETURN lv_yield_dis;

Line 2829: ' msc_trading_partners mp, ' ||

2825: l_plan_type ||',' ||
2826: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
2827: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2828: ' FROM msc_projects mpp, '||
2829: ' msc_trading_partners mp, ' ||
2830: ' msc_trading_partners mp2,' ||
2831: ' msc_system_items msi, ' ||
2832: ' msc_system_items msi1,' ||
2833: ' msc_supplies s, ' ||

Line 2830: ' msc_trading_partners mp2,' ||

2826: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
2827: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2828: ' FROM msc_projects mpp, '||
2829: ' msc_trading_partners mp, ' ||
2830: ' msc_trading_partners mp2,' ||
2831: ' msc_system_items msi, ' ||
2832: ' msc_system_items msi1,' ||
2833: ' msc_supplies s, ' ||
2834: ' msc_plan_organizations_v orgs ' ||

Line 2960: ' msc_trading_partners mp, ' ||

2956: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2957: l_plan_type ||','||
2958: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2959: ' FROM msc_projects mpp, '||
2960: ' msc_trading_partners mp, ' ||
2961: ' msc_trading_partners mp2,' ||
2962: ' msc_system_items msi, ' ||
2963: ' msc_system_items msi1,' ||
2964: ' msc_supplies s,' ||

Line 2961: ' msc_trading_partners mp2,' ||

2957: l_plan_type ||','||
2958: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2959: ' FROM msc_projects mpp, '||
2960: ' msc_trading_partners mp, ' ||
2961: ' msc_trading_partners mp2,' ||
2962: ' msc_system_items msi, ' ||
2963: ' msc_system_items msi1,' ||
2964: ' msc_supplies s,' ||
2965: ' msc_demands d,' ||

Line 3187: ' msc_trading_partners mp, ' ||

3183: l_plan_type ||',' ||
3184: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
3185: ' nvl(s.implement_ship_method,s.ship_method) ' ||
3186: ' FROM msc_projects mpp, ' ||
3187: ' msc_trading_partners mp, ' ||
3188: ' msc_trading_partners mp2, ' ||
3189: 'msc_system_items msi, '||
3190: 'msc_system_items msi1,'||
3191: 'msc_part_supplies s, '||

Line 3188: ' msc_trading_partners mp2, ' ||

3184: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
3185: ' nvl(s.implement_ship_method,s.ship_method) ' ||
3186: ' FROM msc_projects mpp, ' ||
3187: ' msc_trading_partners mp, ' ||
3188: ' msc_trading_partners mp2, ' ||
3189: 'msc_system_items msi, '||
3190: 'msc_system_items msi1,'||
3191: 'msc_part_supplies s, '||
3192: 'msc_plan_organizations_v orgs '||

Line 4003: msc_trading_partners mtp,

3999: Msc_supplies s1,
4000: Msc_supplies s2 ,
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,

Line 4004: msc_trading_partners mtp1,

4000: Msc_supplies s2 ,
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

Line 4159: msc_trading_partners mtp,

4155: msc_system_items msi,
4156: msc_part_supplies s,
4157: msc_part_demands d,
4158: Msc_part_supplies s1,
4159: msc_trading_partners mtp,
4160: msc_trading_partners mtp1,
4161: msc_part_demands d1,
4162: Msc_part_supplies s2,
4163: msc_part_demands d2,

Line 4160: msc_trading_partners mtp1,

4156: msc_part_supplies s,
4157: msc_part_demands d,
4158: Msc_part_supplies s1,
4159: msc_trading_partners mtp,
4160: msc_trading_partners mtp1,
4161: msc_part_demands d1,
4162: Msc_part_supplies s2,
4163: msc_part_demands d2,
4164: msc_system_items msi1,

Line 4603: FROM msc_trading_partners tp,

4599: s.sr_instance_id
4600: -- dsr: 2 new columns
4601: , s.schedule_priority
4602: , nvl(s.requested_completion_date, s.need_by_date)
4603: FROM msc_trading_partners tp,
4604: msc_parameters param,
4605: msc_system_items msi,
4606: msc_process_effectivity mpe,
4607: msc_supplies s

Line 5111: msc_trading_partners tp,

5107: , 3
5108: , resreq.resource_id
5109: , 1
5110: FROM
5111: msc_trading_partners tp,
5112: msc_resource_requirements resreq,
5113: msc_resource_instance_reqs res_instreq, -- changed from design doc
5114: msc_dept_res_instances dep_res_inst,
5115: msc_supplies s,

Line 5230: msc_trading_partners tp,

5226: , 3
5227: , resreq.resource_id
5228: , 1
5229: FROM
5230: msc_trading_partners tp,
5231: msc_resource_requirements resreq,
5232: msc_resource_instance_reqs res_instreq,
5233: msc_dept_res_instances dep_res_inst,
5234: msc_supplies s,

Line 5535: FROM msc_trading_partners tp,

5531: s.transaction_id --Outbound Changes for XML
5532: -- dsr: added 2 new columns
5533: , s.schedule_priority
5534: , s.requested_completion_date
5535: FROM msc_trading_partners tp,
5536: msc_parameters param,
5537: msc_system_items msi,
5538: msc_supplies s,
5539: msc_plan_organizations_v orgs

Line 6063: FROM msc_trading_partners tp,

6059: resreq.parent_seq_num,
6060: 3,
6061: resreq.resource_id,
6062: 1
6063: FROM msc_trading_partners tp,
6064: msc_resource_requirements resreq,
6065: msc_resource_instance_reqs res_instreq, -- changed from design doc
6066: msc_dept_res_instances dep_res_inst,
6067: msc_supplies s,

Line 6181: msc_trading_partners tp,

6177: , 3
6178: , resreq.resource_id
6179: , 1
6180: FROM
6181: msc_trading_partners tp,
6182: msc_resource_requirements resreq,
6183: msc_resource_instance_reqs res_instreq,
6184: msc_dept_res_instances dep_res_inst,
6185: msc_supplies s,

Line 6743: FROM msc_trading_partners tp,

6739: s.sr_instance_id
6740: -- dsr
6741: , s.schedule_priority
6742: , nvl(s.requested_completion_date, s.need_by_date)
6743: FROM msc_trading_partners tp,
6744: msc_parameters param,
6745: msc_system_items msi,
6746: msc_process_effectivity mpe,
6747: msc_supplies s,

Line 6881: FROM msc_trading_partners tp,

6877: 2,
6878: 1,
6879: resreq.operation_sequence_id, --Outbound changes for XML
6880: s.sr_instance_id
6881: FROM msc_trading_partners tp,
6882: msc_resource_requirements resreq,
6883: msc_parameters param,
6884: msc_system_items msi,
6885: msc_supplies s

Line 7043: FROM msc_trading_partners tp,

7039: , resreq.maximum_assigned_units
7040: , resreq.parent_seq_num
7041: , resreq.orig_resource_seq_num
7042: , resreq.resource_seq_num
7043: FROM msc_trading_partners tp,
7044: msc_resource_requirements resreq,
7045: msc_parameters param,
7046: msc_system_items msi,
7047: msc_supplies s,

Line 7168: FROM msc_trading_partners tp,

7164: TO_CHAR(NULL),
7165: -- md.operation_seq_id,
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,

Line 7278: FROM msc_trading_partners tp,

7274: 1,
7275: TO_CHAR(NULL),
7276: nvl(s.implement_uom_code,msi.uom_code),
7277: s.sr_instance_id
7278: FROM msc_trading_partners tp,
7279: msc_system_items icomp,
7280: msc_supplies co,
7281: msc_parameters param,
7282: msc_system_items msi,

Line 7393: FROM msc_trading_partners tp,

7389: TO_CHAR(NULL),
7390: -- md.operation_seq_id,
7391: nvl(s.implement_uom_code,msi.uom_code),
7392: s.sr_instance_id
7393: FROM msc_trading_partners tp,
7394: msc_item_id_lid sr_item,
7395: msc_bom_components subcomp,
7396: msc_component_substitutes bsub,
7397: /* msc_bom_components bcomp, */

Line 7544: FROM msc_trading_partners tp,

7540: -- dsr decode(nvl(resreq.firm_flag,0),0,2,1),
7541: resreq.department_id,
7542: resreq.resource_hours,
7543: resreq.parent_seq_num
7544: FROM msc_trading_partners tp,
7545: msc_resource_requirements resreq,
7546: msc_parameters param,
7547: msc_system_items msi,
7548: msc_supplies s,

Line 7658: msc_trading_partners tp,

7654: -- resreq.alternate_num,
7655: , 1 -- jguo
7656: , resreq.parent_seq_num
7657: FROM
7658: msc_trading_partners tp,
7659: msc_resource_requirements resreq,
7660: msc_resource_instance_reqs res_instreq,
7661: msc_dept_res_instances dep_res_inst,
7662: msc_supplies s

Line 7770: msc_trading_partners tp,

7766: -- resreq.alternate_num
7767: ,1 -- jguo
7768: , resreq.parent_seq_num
7769: FROM
7770: msc_trading_partners tp,
7771: msc_resource_requirements resreq,
7772: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7773: msc_dept_res_instances dep_res_inst,
7774: msc_supplies s

Line 7868: msc_trading_partners tp,

7864: resreq.RESOURCE_ID,
7865: resreq.RESOURCE_ID,
7866: resreq.resource_seq_num
7867: FROM
7868: msc_trading_partners tp,
7869: msc_resource_requirements resreq,
7870: msc_supplies s,
7871: msc_resource_charges chg
7872: WHERE

Line 8271: FROM msc_trading_partners tp,

8267: msi.sr_inventory_item_id,
8268: s.transaction_id --Outbound Changes for XML
8269: , s.schedule_priority -- dsr
8270: , s.requested_completion_date -- dsr
8271: FROM msc_trading_partners tp,
8272: msc_parameters param,
8273: msc_system_items msi,
8274: msc_supplies s,
8275: msc_plan_organizations_v orgs,

Line 8406: FROM msc_trading_partners tp,

8402: s.sr_instance_id,
8403: resreq.operation_sequence_id, --Outbound Changes for XML
8404: s.disposition_id
8405: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
8406: FROM msc_trading_partners tp,
8407: msc_resource_requirements resreq,
8408: msc_parameters param,
8409: msc_system_items msi,
8410: msc_supplies s

Line 8562: FROM msc_trading_partners tp,

8558: , resreq.parent_seq_num
8559: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8560: , resreq.orig_resource_seq_num
8561: , resreq.resource_seq_num
8562: FROM msc_trading_partners tp,
8563: msc_resource_requirements resreq,
8564: msc_parameters param,
8565: msc_system_items msi,
8566: msc_supplies s

Line 8688: FROM msc_trading_partners tp,

8684: -- md.operation_seq_id,
8685: nvl(s.implement_uom_code, msi.uom_code),
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,

Line 8822: FROM msc_trading_partners tp,

8818: s.sr_instance_id,
8819: nvl(s.implement_uom_code, msi.uom_code),
8820: s.disposition_id
8821: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8822: FROM msc_trading_partners tp,
8823: msc_system_items icomp,
8824: msc_supplies co,
8825: msc_parameters param,
8826: msc_system_items msi,

Line 8957: FROM msc_trading_partners tp,

8953: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8954: , resreq.orig_resource_seq_num
8955: , resreq.resource_seq_num
8956: ,resreq.parent_seq_num
8957: FROM msc_trading_partners tp,
8958: msc_resource_requirements resreq,
8959: msc_parameters param,
8960: msc_system_items msi,
8961: msc_supplies s

Line 9065: msc_trading_partners tp,

9061: , s.disposition_id -- for reschedule
9062: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
9063: , resreq.parent_seq_num
9064: FROM
9065: msc_trading_partners tp,
9066: msc_resource_requirements resreq,
9067: msc_resource_instance_reqs res_instreq,
9068: msc_dept_res_instances dep_res_inst,
9069: msc_supplies s

Line 9183: msc_trading_partners tp,

9179: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
9180: , 1 -- jguo
9181: ,resreq.parent_seq_num
9182: FROM
9183: msc_trading_partners tp,
9184: msc_resource_requirements resreq,
9185: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
9186: msc_dept_res_instances dep_res_inst,
9187: msc_supplies s

Line 9287: msc_trading_partners tp,

9283: , resreq.RESOURCE_ID
9284: , resreq.RESOURCE_ID
9285: , resreq.resource_seq_num
9286: FROM
9287: msc_trading_partners tp,
9288: msc_resource_requirements resreq,
9289: msc_supplies s,
9290: msc_resource_charges chg
9291: WHERE

Line 9408: FROM msc_trading_partners tp,

9404: ''Y'',
9405: s.transaction_id,
9406: nvl(s.implement_uom_code,msi.uom_code),
9407: s.sr_instance_id
9408: FROM msc_trading_partners tp,
9409: msc_parameters param,
9410: msc_system_items msi,
9411: msc_process_effectivity mpe,
9412: msc_supplies s,

Line 9652: msc_trading_partners mp, -- mtl_parameters mp,

9648: --msc_calendar_dates cal1,
9649: --msc_calendar_dates cal2,
9650: msc_tp_id_lid supplier,
9651: msc_trading_partner_sites mtps,
9652: msc_trading_partners mp, -- mtl_parameters mp,
9653: msc_trading_partners mp1,
9654: msc_system_items msi,
9655: msc_system_items msi1,
9656: msc_supplies s,

Line 9653: msc_trading_partners mp1,

9649: --msc_calendar_dates cal2,
9650: msc_tp_id_lid supplier,
9651: msc_trading_partner_sites mtps,
9652: msc_trading_partners mp, -- mtl_parameters mp,
9653: msc_trading_partners mp1,
9654: msc_system_items msi,
9655: msc_system_items msi1,
9656: msc_supplies s,
9657: msc_item_suppliers mis,

Line 9798: msc_trading_partners mp, -- mtl_parameters mp,

9794: -- msc_calendar_dates cal1,
9795: -- msc_calendar_dates cal2,
9796: msc_tp_id_lid supplier,
9797: msc_trading_partner_sites mtps,
9798: msc_trading_partners mp, -- mtl_parameters mp,
9799: msc_trading_partners mp1,
9800: msc_system_items msi,
9801: msc_system_items msi1,
9802: msc_item_suppliers mis,

Line 9799: msc_trading_partners mp1,

9795: -- msc_calendar_dates cal2,
9796: msc_tp_id_lid supplier,
9797: msc_trading_partner_sites mtps,
9798: msc_trading_partners mp, -- mtl_parameters mp,
9799: msc_trading_partners mp1,
9800: msc_system_items msi,
9801: msc_system_items msi1,
9802: msc_item_suppliers mis,
9803: msc_supplies s,

Line 9943: msc_trading_partners mp, -- mtl_parameters mp,

9939: -- msc_calendar_dates cal1,
9940: -- msc_calendar_dates cal2,
9941: msc_tp_id_lid supplier,
9942: msc_trading_partner_sites mtps,
9943: msc_trading_partners mp, -- mtl_parameters mp,
9944: msc_trading_partners mp1,
9945: msc_system_items msi,
9946: msc_system_items msi1,
9947: msc_item_suppliers mis,

Line 9944: msc_trading_partners mp1,

9940: -- msc_calendar_dates cal2,
9941: msc_tp_id_lid supplier,
9942: msc_trading_partner_sites mtps,
9943: msc_trading_partners mp, -- mtl_parameters mp,
9944: msc_trading_partners mp1,
9945: msc_system_items msi,
9946: msc_system_items msi1,
9947: msc_item_suppliers mis,
9948: msc_supplies s,

Line 10099: msc_trading_partners mp,

10095: s.sr_instance_id,
10096: g_batch_id
10097: FROM --msc_calendar_dates cal1,
10098: --msc_calendar_dates cal2,
10099: msc_trading_partners mp,
10100: msc_system_items msi,
10101: msc_supplies s,
10102: msc_apps_instances mai, -- IR/ISO resch Proj
10103: msc_plan_organizations_v orgs

Line 10158: msc_trading_partners mp,

10154: s.sr_instance_id,
10155: g_batch_id
10156: FROM --msc_calendar_dates cal1,
10157: --msc_calendar_dates cal2,
10158: msc_trading_partners mp,
10159: msc_system_items msi,
10160: msc_supplies s,
10161: msc_plan_organizations_v orgs
10162: WHERE --cal1.sr_instance_id= mp.sr_instance_id

Line 10267: msc_trading_partners mp,

10263: lv_po_line_id,
10264: lv_po_number
10265: FROM --msc_calendar_dates cal1,
10266: --msc_calendar_dates cal2,
10267: msc_trading_partners mp,
10268: msc_system_items msi,
10269: msc_supplies s,
10270: msc_plan_organizations_v orgs
10271: WHERE --cal1.sr_instance_id = mp.sr_instance_id

Line 10651: FROM msc_trading_partners tp,

10647: nvl(s.implement_uom_code,msi.uom_code),
10648: s.sr_instance_id
10649: , s.schedule_priority
10650: , nvl(s.requested_completion_date, s.need_by_date)
10651: FROM msc_trading_partners tp,
10652: msc_parameters param,
10653: msc_system_items msi,
10654: msc_process_effectivity mpe,
10655: msc_supplies s

Line 11042: FROM msc_trading_partners tp,

11038: msi.sr_inventory_item_id,
11039: s.transaction_id
11040: , s.schedule_priority
11041: , s.requested_completion_date
11042: FROM msc_trading_partners tp,
11043: msc_parameters param,
11044: msc_system_items msi,
11045: msc_supplies s,
11046: msc_plan_organizations_v orgs

Line 11160: FROM msc_trading_partners tp,

11156: s.sr_instance_id,
11157: resreq.operation_sequence_id, --Outbound Changes for XML
11158: s.disposition_id
11159: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
11160: FROM msc_trading_partners tp,
11161: msc_resource_requirements resreq,
11162: msc_parameters param,
11163: msc_system_items msi,
11164: msc_supplies s

Line 11311: FROM msc_trading_partners tp,

11307: , resreq.parent_seq_num
11308: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11309: , resreq.orig_resource_seq_num
11310: , resreq.resource_seq_num
11311: FROM msc_trading_partners tp,
11312: msc_resource_requirements resreq,
11313: msc_parameters param,
11314: msc_system_items msi,
11315: msc_supplies s

Line 11415: FROM msc_trading_partners tp,

11411: s.sr_instance_id,
11412: nvl(s.implement_uom_code, msi.uom_code),
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,

Line 11531: FROM msc_trading_partners tp,

11527: s.sr_instance_id,
11528: nvl(s.implement_uom_code, msi.uom_code),
11529: s.disposition_id
11530: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11531: FROM msc_trading_partners tp,
11532: msc_system_items icomp,
11533: msc_supplies co,
11534: msc_parameters param,
11535: msc_system_items msi,

Line 11659: FROM msc_trading_partners tp,

11655: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11656: , resreq.orig_resource_seq_num
11657: , resreq.resource_seq_num
11658: ,resreq.parent_seq_num
11659: FROM msc_trading_partners tp,
11660: msc_resource_requirements resreq,
11661: msc_parameters param,
11662: msc_system_items msi,
11663: msc_supplies s

Line 11769: msc_trading_partners tp,

11765: , s.disposition_id -- for reschedule
11766: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11767: , resreq.parent_seq_num
11768: FROM
11769: msc_trading_partners tp,
11770: msc_resource_requirements resreq,
11771: msc_resource_instance_reqs res_instreq,
11772: msc_dept_res_instances dep_res_inst,
11773: msc_supplies s

Line 11889: msc_trading_partners tp,

11885: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
11886: , 1 -- jguo
11887: ,resreq.parent_seq_num
11888: FROM
11889: msc_trading_partners tp,
11890: msc_resource_requirements resreq,
11891: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
11892: msc_dept_res_instances dep_res_inst,
11893: msc_supplies s

Line 11995: msc_trading_partners tp,

11991: , resreq.RESOURCE_ID
11992: , resreq.RESOURCE_ID
11993: , resreq.resource_seq_num
11994: FROM
11995: msc_trading_partners tp,
11996: msc_resource_requirements resreq,
11997: msc_supplies s,
11998: msc_resource_charges chg
11999: WHERE

Line 12371: FROM msc_trading_partners tp,

12367: msi.sr_inventory_item_id,
12368: s.transaction_id
12369: , s.schedule_priority
12370: , s.requested_completion_date
12371: FROM msc_trading_partners tp,
12372: msc_parameters param,
12373: msc_system_items msi,
12374: msc_supplies s,
12375: msc_plan_organizations_v orgs

Line 12489: FROM msc_trading_partners tp,

12485: s.sr_instance_id,
12486: resreq.operation_sequence_id, --Outbound Changes for XML
12487: s.disposition_id
12488: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
12489: FROM msc_trading_partners tp,
12490: msc_resource_requirements resreq,
12491: msc_parameters param,
12492: msc_system_items msi,
12493: msc_supplies s

Line 12640: FROM msc_trading_partners tp,

12636: , resreq.parent_seq_num
12637: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12638: , resreq.orig_resource_seq_num
12639: , resreq.resource_seq_num
12640: FROM msc_trading_partners tp,
12641: msc_resource_requirements resreq,
12642: msc_parameters param,
12643: msc_system_items msi,
12644: msc_supplies s

Line 12745: FROM msc_trading_partners tp,

12741: s.sr_instance_id,
12742: nvl(s.implement_uom_code, msi.uom_code),
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,

Line 12862: FROM msc_trading_partners tp,

12858: s.sr_instance_id,
12859: nvl(s.implement_uom_code, msi.uom_code),
12860: s.disposition_id
12861: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12862: FROM msc_trading_partners tp,
12863: msc_system_items icomp,
12864: msc_supplies co,
12865: msc_parameters param,
12866: msc_system_items msi,

Line 12990: FROM msc_trading_partners tp,

12986: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
12987: , resreq.orig_resource_seq_num
12988: , resreq.resource_seq_num
12989: ,resreq.parent_seq_num
12990: FROM msc_trading_partners tp,
12991: msc_resource_requirements resreq,
12992: msc_parameters param,
12993: msc_system_items msi,
12994: msc_supplies s

Line 13100: msc_trading_partners tp,

13096: , s.disposition_id -- for reschedule
13097: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
13098: , resreq.parent_seq_num
13099: FROM
13100: msc_trading_partners tp,
13101: msc_resource_requirements resreq,
13102: msc_resource_instance_reqs res_instreq,
13103: msc_dept_res_instances dep_res_inst,
13104: msc_supplies s

Line 13220: msc_trading_partners tp,

13216: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
13217: , 1 -- jguo
13218: ,resreq.parent_seq_num
13219: FROM
13220: msc_trading_partners tp,
13221: msc_resource_requirements resreq,
13222: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
13223: msc_dept_res_instances dep_res_inst,
13224: msc_supplies s

Line 13326: msc_trading_partners tp,

13322: , resreq.RESOURCE_ID
13323: , resreq.RESOURCE_ID
13324: , resreq.resource_seq_num
13325: FROM
13326: msc_trading_partners tp,
13327: msc_resource_requirements resreq,
13328: msc_supplies s,
13329: msc_resource_charges chg
13330: WHERE

Line 13428: FROM msc_trading_partners tp,

13424: ms.sr_instance_id,
13425: nvl(ms.implement_uom_code, msi.uom_code),
13426: ms.disposition_id
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,