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 270: and for the OPM orgs organization_type = 2 in msc_trading_partners */

266:
267: lv_yield_dis := 0;
268:
269: /* For bug: 2559388 - added this If cond to return RCY=1 (for OPM, there is no RCY concept ,so return 1
270: and for the OPM orgs organization_type = 2 in msc_trading_partners */
271:
272: IF (org_type = 2) THEN
273: lv_yield_dis := 1;
274: RETURN lv_yield_dis;

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

328:
329: lv_yield_dis := 0;
330:
331: /* For bug: 2559388 - added this If cond to return RCY=1 (for OPM, there is no RCY concept ,so return 1
332: and for the OPM orgs organization_type = 2 in msc_trading_partners */
333:
334: IF (org_type = 2) THEN
335: lv_yield_dis := 1;
336: RETURN lv_yield_dis;

Line 2294: ' msc_trading_partners mp, ' ||

2290: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2291: l_plan_type ||',' ||
2292: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2293: ' FROM msc_projects mpp, '||
2294: ' msc_trading_partners mp, ' ||
2295: ' msc_trading_partners mp2,' ||
2296: ' msc_system_items msi, ' ||
2297: ' msc_system_items msi1,' ||
2298: ' msc_supplies s, ' ||

Line 2295: ' msc_trading_partners mp2,' ||

2291: l_plan_type ||',' ||
2292: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2293: ' FROM msc_projects mpp, '||
2294: ' msc_trading_partners mp, ' ||
2295: ' msc_trading_partners mp2,' ||
2296: ' msc_system_items msi, ' ||
2297: ' msc_system_items msi1,' ||
2298: ' msc_supplies s, ' ||
2299: ' msc_plan_organizations_v orgs ' ||

Line 2424: ' msc_trading_partners mp, ' ||

2420: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2421: l_plan_type ||','||
2422: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2423: ' FROM msc_projects mpp, '||
2424: ' msc_trading_partners mp, ' ||
2425: ' msc_trading_partners mp2,' ||
2426: ' msc_system_items msi, ' ||
2427: ' msc_system_items msi1,' ||
2428: ' msc_supplies s,' ||

Line 2425: ' msc_trading_partners mp2,' ||

2421: l_plan_type ||','||
2422: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2423: ' FROM msc_projects mpp, '||
2424: ' msc_trading_partners mp, ' ||
2425: ' msc_trading_partners mp2,' ||
2426: ' msc_system_items msi, ' ||
2427: ' msc_system_items msi1,' ||
2428: ' msc_supplies s,' ||
2429: ' msc_demands d,' ||

Line 2647: ' msc_trading_partners mp, ' ||

2643: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2644: l_plan_type ||',' ||
2645: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2646: ' FROM msc_projects mpp, ' ||
2647: ' msc_trading_partners mp, ' ||
2648: ' msc_trading_partners mp2, ' ||
2649: 'msc_system_items msi, '||
2650: 'msc_system_items msi1,'||
2651: 'msc_part_supplies s, '||

Line 2648: ' msc_trading_partners mp2, ' ||

2644: l_plan_type ||',' ||
2645: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2646: ' FROM msc_projects mpp, ' ||
2647: ' msc_trading_partners mp, ' ||
2648: ' msc_trading_partners mp2, ' ||
2649: 'msc_system_items msi, '||
2650: 'msc_system_items msi1,'||
2651: 'msc_part_supplies s, '||
2652: 'msc_plan_organizations_v orgs '||

Line 3463: msc_trading_partners mtp,

3459: Msc_supplies s1,
3460: Msc_supplies s2 ,
3461: msc_system_items msi,
3462: msc_system_items msi1,
3463: msc_trading_partners mtp,
3464: msc_trading_partners mtp1,
3465: msc_demands d ,
3466: msc_demands d1,
3467: msc_demands d2,

Line 3464: msc_trading_partners mtp1,

3460: Msc_supplies s2 ,
3461: msc_system_items msi,
3462: msc_system_items msi1,
3463: msc_trading_partners mtp,
3464: msc_trading_partners mtp1,
3465: msc_demands d ,
3466: msc_demands d1,
3467: msc_demands d2,
3468: ( select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id

Line 3618: msc_trading_partners mtp,

3614: msc_system_items msi,
3615: msc_part_supplies s,
3616: msc_part_demands d,
3617: Msc_part_supplies s1,
3618: msc_trading_partners mtp,
3619: msc_trading_partners mtp1,
3620: msc_part_demands d1,
3621: Msc_part_supplies s2,
3622: msc_part_demands d2,

Line 3619: msc_trading_partners mtp1,

3615: msc_part_supplies s,
3616: msc_part_demands d,
3617: Msc_part_supplies s1,
3618: msc_trading_partners mtp,
3619: msc_trading_partners mtp1,
3620: msc_part_demands d1,
3621: Msc_part_supplies s2,
3622: msc_part_demands d2,
3623: msc_system_items msi1,

Line 4054: FROM msc_trading_partners tp,

4050: s.sr_instance_id
4051: -- dsr: 2 new columns
4052: , s.schedule_priority
4053: , nvl(s.requested_completion_date, s.need_by_date)
4054: FROM msc_trading_partners tp,
4055: msc_parameters param,
4056: msc_system_items msi,
4057: msc_process_effectivity mpe,
4058: msc_supplies s

Line 4562: msc_trading_partners tp,

4558: , 3
4559: , resreq.resource_id
4560: , 1
4561: FROM
4562: msc_trading_partners tp,
4563: msc_resource_requirements resreq,
4564: msc_resource_instance_reqs res_instreq, -- changed from design doc
4565: msc_dept_res_instances dep_res_inst,
4566: msc_supplies s,

Line 4681: msc_trading_partners tp,

4677: , 3
4678: , resreq.resource_id
4679: , 1
4680: FROM
4681: msc_trading_partners tp,
4682: msc_resource_requirements resreq,
4683: msc_resource_instance_reqs res_instreq,
4684: msc_dept_res_instances dep_res_inst,
4685: msc_supplies s,

Line 4979: FROM msc_trading_partners tp,

4975: s.transaction_id --Outbound Changes for XML
4976: -- dsr: added 2 new columns
4977: , s.schedule_priority
4978: , s.requested_completion_date
4979: FROM msc_trading_partners tp,
4980: msc_parameters param,
4981: msc_system_items msi,
4982: msc_supplies s,
4983: msc_plan_organizations_v orgs

Line 5507: FROM msc_trading_partners tp,

5503: resreq.parent_seq_num,
5504: 3,
5505: resreq.resource_id,
5506: 1
5507: FROM msc_trading_partners tp,
5508: msc_resource_requirements resreq,
5509: msc_resource_instance_reqs res_instreq, -- changed from design doc
5510: msc_dept_res_instances dep_res_inst,
5511: msc_supplies s,

Line 5625: msc_trading_partners tp,

5621: , 3
5622: , resreq.resource_id
5623: , 1
5624: FROM
5625: msc_trading_partners tp,
5626: msc_resource_requirements resreq,
5627: msc_resource_instance_reqs res_instreq,
5628: msc_dept_res_instances dep_res_inst,
5629: msc_supplies s,

Line 6082: FROM msc_trading_partners tp,

6078: s.sr_instance_id
6079: -- dsr
6080: , s.schedule_priority
6081: , nvl(s.requested_completion_date, s.need_by_date)
6082: FROM msc_trading_partners tp,
6083: msc_parameters param,
6084: msc_system_items msi,
6085: msc_process_effectivity mpe,
6086: msc_supplies s

Line 6212: FROM msc_trading_partners tp,

6208: 2,
6209: 1,
6210: resreq.operation_sequence_id, --Outbound changes for XML
6211: s.sr_instance_id
6212: FROM msc_trading_partners tp,
6213: msc_resource_requirements resreq,
6214: msc_parameters param,
6215: msc_system_items msi,
6216: msc_supplies s

Line 6374: FROM msc_trading_partners tp,

6370: , resreq.maximum_assigned_units
6371: , resreq.parent_seq_num
6372: , resreq.orig_resource_seq_num
6373: , resreq.resource_seq_num
6374: FROM msc_trading_partners tp,
6375: msc_resource_requirements resreq,
6376: msc_parameters param,
6377: msc_system_items msi,
6378: msc_supplies s,

Line 6494: FROM msc_trading_partners tp,

6490: TO_CHAR(NULL),
6491: -- md.operation_seq_id,
6492: nvl(s.implement_uom_code,msi.uom_code),
6493: s.sr_instance_id
6494: FROM msc_trading_partners tp,
6495: msc_system_items icomp,
6496: msc_demands md,
6497: msc_parameters param,
6498: msc_system_items msi,

Line 6599: FROM msc_trading_partners tp,

6595: 1,
6596: TO_CHAR(NULL),
6597: nvl(s.implement_uom_code,msi.uom_code),
6598: s.sr_instance_id
6599: FROM msc_trading_partners tp,
6600: msc_system_items icomp,
6601: msc_supplies co,
6602: msc_parameters param,
6603: msc_system_items msi,

Line 6714: FROM msc_trading_partners tp,

6710: TO_CHAR(NULL),
6711: -- md.operation_seq_id,
6712: nvl(s.implement_uom_code,msi.uom_code),
6713: s.sr_instance_id
6714: FROM msc_trading_partners tp,
6715: msc_item_id_lid sr_item,
6716: msc_bom_components subcomp,
6717: msc_component_substitutes bsub,
6718: /* msc_bom_components bcomp, */

Line 6865: FROM msc_trading_partners tp,

6861: -- dsr decode(nvl(resreq.firm_flag,0),0,2,1),
6862: resreq.department_id,
6863: resreq.resource_hours,
6864: resreq.parent_seq_num
6865: FROM msc_trading_partners tp,
6866: msc_resource_requirements resreq,
6867: msc_parameters param,
6868: msc_system_items msi,
6869: msc_supplies s,

Line 6979: msc_trading_partners tp,

6975: -- resreq.alternate_num,
6976: , 1 -- jguo
6977: , resreq.parent_seq_num
6978: FROM
6979: msc_trading_partners tp,
6980: msc_resource_requirements resreq,
6981: msc_resource_instance_reqs res_instreq,
6982: msc_dept_res_instances dep_res_inst,
6983: msc_supplies s

Line 7091: msc_trading_partners tp,

7087: -- resreq.alternate_num
7088: ,1 -- jguo
7089: , resreq.parent_seq_num
7090: FROM
7091: msc_trading_partners tp,
7092: msc_resource_requirements resreq,
7093: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
7094: msc_dept_res_instances dep_res_inst,
7095: msc_supplies s

Line 7189: msc_trading_partners tp,

7185: resreq.RESOURCE_ID,
7186: resreq.RESOURCE_ID,
7187: resreq.resource_seq_num
7188: FROM
7189: msc_trading_partners tp,
7190: msc_resource_requirements resreq,
7191: msc_supplies s,
7192: msc_resource_charges chg
7193: WHERE

Line 7490: FROM msc_trading_partners tp,

7486: msi.sr_inventory_item_id,
7487: s.transaction_id --Outbound Changes for XML
7488: , s.schedule_priority -- dsr
7489: , s.requested_completion_date -- dsr
7490: FROM msc_trading_partners tp,
7491: msc_parameters param,
7492: msc_system_items msi,
7493: msc_supplies s,
7494: msc_plan_organizations_v orgs

Line 7617: FROM msc_trading_partners tp,

7613: s.sr_instance_id,
7614: resreq.operation_sequence_id, --Outbound Changes for XML
7615: s.disposition_id
7616: , decode(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr
7617: FROM msc_trading_partners tp,
7618: msc_resource_requirements resreq,
7619: msc_parameters param,
7620: msc_system_items msi,
7621: msc_supplies s

Line 7766: FROM msc_trading_partners tp,

7762: , resreq.parent_seq_num
7763: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
7764: , resreq.orig_resource_seq_num
7765: , resreq.resource_seq_num
7766: FROM msc_trading_partners tp,
7767: msc_resource_requirements resreq,
7768: msc_parameters param,
7769: msc_system_items msi,
7770: msc_supplies s

Line 7872: FROM msc_trading_partners tp,

7868: -- md.operation_seq_id,
7869: nvl(s.implement_uom_code, msi.uom_code),
7870: s.disposition_id
7871: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
7872: FROM msc_trading_partners tp,
7873: msc_system_items icomp,
7874: msc_demands md,
7875: msc_parameters param,
7876: msc_system_items msi,

Line 7986: FROM msc_trading_partners tp,

7982: s.sr_instance_id,
7983: nvl(s.implement_uom_code, msi.uom_code),
7984: s.disposition_id
7985: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
7986: FROM msc_trading_partners tp,
7987: msc_system_items icomp,
7988: msc_supplies co,
7989: msc_parameters param,
7990: msc_system_items msi,

Line 8114: FROM msc_trading_partners tp,

8110: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8111: , resreq.orig_resource_seq_num
8112: , resreq.resource_seq_num
8113: ,resreq.parent_seq_num
8114: FROM msc_trading_partners tp,
8115: msc_resource_requirements resreq,
8116: msc_parameters param,
8117: msc_system_items msi,
8118: msc_supplies s

Line 8222: msc_trading_partners tp,

8218: , s.disposition_id -- for reschedule
8219: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8220: , resreq.parent_seq_num
8221: FROM
8222: msc_trading_partners tp,
8223: msc_resource_requirements resreq,
8224: msc_resource_instance_reqs res_instreq,
8225: msc_dept_res_instances dep_res_inst,
8226: msc_supplies s

Line 8340: msc_trading_partners tp,

8336: , DECODE(arg_load_type, EAM_RESCHEDULE_WORK_ORDER, SYS_YES, SYS_NO) -- dsr: eam_flag
8337: , 1 -- jguo
8338: ,resreq.parent_seq_num
8339: FROM
8340: msc_trading_partners tp,
8341: msc_resource_requirements resreq,
8342: msc_resource_instance_reqs res_instreq, -- ??? msc_res_inst_requirements res_instreq,
8343: msc_dept_res_instances dep_res_inst,
8344: msc_supplies s

Line 8444: msc_trading_partners tp,

8440: , resreq.RESOURCE_ID
8441: , resreq.RESOURCE_ID
8442: , resreq.resource_seq_num
8443: FROM
8444: msc_trading_partners tp,
8445: msc_resource_requirements resreq,
8446: msc_supplies s,
8447: msc_resource_charges chg
8448: WHERE

Line 8565: FROM msc_trading_partners tp,

8561: ''Y'',
8562: s.transaction_id,
8563: nvl(s.implement_uom_code,msi.uom_code),
8564: s.sr_instance_id
8565: FROM msc_trading_partners tp,
8566: msc_parameters param,
8567: msc_system_items msi,
8568: msc_process_effectivity mpe,
8569: msc_supplies s,

Line 8792: msc_trading_partners mp, -- mtl_parameters mp,

8788: --msc_calendar_dates cal1,
8789: --msc_calendar_dates cal2,
8790: msc_tp_id_lid supplier,
8791: msc_trading_partner_sites mtps,
8792: msc_trading_partners mp, -- mtl_parameters mp,
8793: msc_trading_partners mp1,
8794: msc_system_items msi,
8795: msc_system_items msi1,
8796: msc_supplies s,

Line 8793: msc_trading_partners mp1,

8789: --msc_calendar_dates cal2,
8790: msc_tp_id_lid supplier,
8791: msc_trading_partner_sites mtps,
8792: msc_trading_partners mp, -- mtl_parameters mp,
8793: msc_trading_partners mp1,
8794: msc_system_items msi,
8795: msc_system_items msi1,
8796: msc_supplies s,
8797: msc_item_suppliers mis,

Line 8935: msc_trading_partners mp, -- mtl_parameters mp,

8931: -- msc_calendar_dates cal1,
8932: -- msc_calendar_dates cal2,
8933: msc_tp_id_lid supplier,
8934: msc_trading_partner_sites mtps,
8935: msc_trading_partners mp, -- mtl_parameters mp,
8936: msc_trading_partners mp1,
8937: msc_system_items msi,
8938: msc_system_items msi1,
8939: msc_item_suppliers mis,

Line 8936: msc_trading_partners mp1,

8932: -- msc_calendar_dates cal2,
8933: msc_tp_id_lid supplier,
8934: msc_trading_partner_sites mtps,
8935: msc_trading_partners mp, -- mtl_parameters mp,
8936: msc_trading_partners mp1,
8937: msc_system_items msi,
8938: msc_system_items msi1,
8939: msc_item_suppliers mis,
8940: msc_supplies s,

Line 9077: msc_trading_partners mp, -- mtl_parameters mp,

9073: -- msc_calendar_dates cal1,
9074: -- msc_calendar_dates cal2,
9075: msc_tp_id_lid supplier,
9076: msc_trading_partner_sites mtps,
9077: msc_trading_partners mp, -- mtl_parameters mp,
9078: msc_trading_partners mp1,
9079: msc_system_items msi,
9080: msc_system_items msi1,
9081: msc_item_suppliers mis,

Line 9078: msc_trading_partners mp1,

9074: -- msc_calendar_dates cal2,
9075: msc_tp_id_lid supplier,
9076: msc_trading_partner_sites mtps,
9077: msc_trading_partners mp, -- mtl_parameters mp,
9078: msc_trading_partners mp1,
9079: msc_system_items msi,
9080: msc_system_items msi1,
9081: msc_item_suppliers mis,
9082: msc_supplies s,

Line 9230: msc_trading_partners mp,

9226: s.sr_instance_id,
9227: g_batch_id
9228: FROM --msc_calendar_dates cal1,
9229: --msc_calendar_dates cal2,
9230: msc_trading_partners mp,
9231: msc_system_items msi,
9232: msc_supplies s,
9233: msc_apps_instances mai, -- IR/ISO resch Proj
9234: msc_plan_organizations_v orgs

Line 9289: msc_trading_partners mp,

9285: s.sr_instance_id,
9286: g_batch_id
9287: FROM --msc_calendar_dates cal1,
9288: --msc_calendar_dates cal2,
9289: msc_trading_partners mp,
9290: msc_system_items msi,
9291: msc_supplies s,
9292: msc_plan_organizations_v orgs
9293: WHERE --cal1.sr_instance_id= mp.sr_instance_id

Line 9398: msc_trading_partners mp,

9394: lv_po_line_id,
9395: lv_po_number
9396: FROM --msc_calendar_dates cal1,
9397: --msc_calendar_dates cal2,
9398: msc_trading_partners mp,
9399: msc_system_items msi,
9400: msc_supplies s,
9401: msc_plan_organizations_v orgs
9402: WHERE --cal1.sr_instance_id = mp.sr_instance_id