[Home] [Help]
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
4059: WHERE tp.sr_tp_id= msi.organization_id
4127: s.sr_instance_id
4128: From msc_supplies s,
4129: msc_operation_networks nwk,
4130: msc_apps_instances ins,
4131: msc_parameters param
4132: Where nwk.plan_id = s.plan_id
4133: AND nwk.sr_instance_id = s.sr_instance_id
4134: AND nwk.routing_sequence_id = s.routing_sequence_id
4135: AND nwk.transition_type = 1
4185: max(nvl(res.CUMMULATIVE_QUANTITY,0))
4186: From msc_supplies s,
4187: msc_resource_requirements res,
4188: msc_apps_instances ins,
4189: msc_parameters param
4190: Where res.plan_id = s.plan_id
4191: AND res.sr_instance_id = s.sr_instance_id
4192: AND s.transaction_id = res.supply_id
4193: AND res.parent_id = 2
4285: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
4286: From msc_supplies s,
4287: msc_resource_requirements res,
4288: msc_apps_instances ins,
4289: msc_parameters param,
4290: msc_department_resources mdr,
4291: msc_system_items msi
4292: Where res.plan_id = s.plan_id
4293: AND res.sr_instance_id = s.sr_instance_id
4374: msc_system_items icomp,
4375: msc_system_items icomp1,
4376: msc_system_items icomp2,
4377: msc_apps_instances ins,
4378: msc_parameters param
4379: Where /* not exists (select 'x'
4380: from msc_exception_details excp
4381: where excp.plan_id = s.plan_id
4382: and excp.number1 = s.transaction_id
4468: , res.parent_seq_num
4469: From msc_supplies s,
4470: msc_resource_requirements res,
4471: msc_apps_instances ins,
4472: msc_parameters param
4473: Where res.plan_id = s.plan_id
4474: AND res.sr_instance_id = s.sr_instance_id
4475: AND s.transaction_id = res.supply_id
4476: AND res.parent_id = 1
4564: msc_resource_instance_reqs res_instreq, -- changed from design doc
4565: msc_dept_res_instances dep_res_inst,
4566: msc_supplies s,
4567: msc_apps_instances ins,
4568: msc_parameters param
4569: WHERE
4570: tp.sr_tp_id=s.organization_id
4571: AND tp.sr_instance_id= s.sr_instance_id
4572: AND tp.partner_type=3
4683: msc_resource_instance_reqs res_instreq,
4684: msc_dept_res_instances dep_res_inst,
4685: msc_supplies s,
4686: msc_apps_instances ins,
4687: msc_parameters param
4688: WHERE
4689: tp.sr_tp_id=s.organization_id
4690: AND tp.sr_instance_id= s.sr_instance_id
4691: AND tp.partner_type=3
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
4984: WHERE tp.sr_tp_id= msi.organization_id
5058: s.sr_instance_id
5059: From msc_supplies s,
5060: msc_job_operation_networks nwk,
5061: msc_apps_instances ins,
5062: msc_parameters param
5063: Where nwk.plan_id = s.plan_id
5064: AND nwk.sr_instance_id = s.sr_instance_id
5065: AND nwk.transaction_id = s.transaction_id
5066: AND nwk.recommended = 'Y'
5118: max(nvl(res.CUMMULATIVE_QUANTITY,0))
5119: From msc_supplies s,
5120: msc_resource_requirements res,
5121: msc_apps_instances ins,
5122: msc_parameters param
5123: Where res.plan_id = s.plan_id
5124: AND res.sr_instance_id = s.sr_instance_id
5125: AND s.transaction_id = res.supply_id
5126: AND res.parent_id = 2
5223: , decode(nvl(res.schedule_flag,1),-23453,1,1,1,res.schedule_flag)
5224: From msc_supplies s,
5225: msc_resource_requirements res,
5226: msc_apps_instances ins,
5227: msc_parameters param,
5228: msc_department_resources mdr,
5229: msc_system_items msi
5230: Where res.plan_id = s.plan_id
5231: AND res.sr_instance_id = s.sr_instance_id
5314: msc_system_items icomp,
5315: msc_system_items icomp1,
5316: msc_system_items icomp2,
5317: msc_apps_instances ins,
5318: msc_parameters param
5319: Where /* not exists (select 'x'
5320: from msc_exception_details excp
5321: where excp.plan_id = s.plan_id
5322: and excp.number1 = s.transaction_id
5409: res.parent_seq_num
5410: From msc_supplies s,
5411: msc_resource_requirements res,
5412: msc_apps_instances ins,
5413: msc_parameters param
5414: Where res.plan_id = s.plan_id
5415: AND res.sr_instance_id = s.sr_instance_id
5416: AND s.transaction_id = res.supply_id
5417: AND res.parent_id = 1
5509: msc_resource_instance_reqs res_instreq, -- changed from design doc
5510: msc_dept_res_instances dep_res_inst,
5511: msc_supplies s,
5512: msc_apps_instances ins,
5513: msc_parameters param
5514: WHERE
5515: tp.sr_tp_id=s.organization_id
5516: AND tp.sr_instance_id= s.sr_instance_id
5517: AND tp.partner_type=3
5627: msc_resource_instance_reqs res_instreq,
5628: msc_dept_res_instances dep_res_inst,
5629: msc_supplies s,
5630: msc_apps_instances ins,
5631: msc_parameters param
5632: WHERE
5633: tp.sr_tp_id=s.organization_id
5634: AND tp.sr_instance_id= s.sr_instance_id
5635: AND tp.partner_type=3
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
6087: WHERE tp.sr_tp_id= msi.organization_id
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
6217: WHERE tp.sr_tp_id= msi.organization_id
6218: AND tp.sr_instance_id= msi.sr_instance_id
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,
6379: msc_department_resources mdr
6380: WHERE tp.sr_tp_id= msi.organization_id
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,
6499: msc_supplies s
6500: WHERE /*
6501: ( md.SUBST_ITEM_FLAG <> 1
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,
6604: msc_supplies s
6605: WHERE /* not exists (select 'x'
6606: from msc_exception_details excp
6718: /* msc_bom_components bcomp, */
6719: msc_boms bom,
6720: msc_system_items icomp,
6721: msc_demands md,
6722: msc_parameters param,
6723: msc_system_items msi,
6724: msc_supplies s
6725: WHERE tp.sr_tp_id= msi.organization_id
6726: AND tp.sr_instance_id= msi.sr_instance_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,
6870: msc_department_resources mdr
6871: WHERE tp.sr_tp_id= msi.organization_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
7495: WHERE tp.sr_tp_id= msi.organization_id
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
7622: WHERE tp.sr_tp_id= msi.organization_id
7623: AND tp.sr_instance_id= msi.sr_instance_id
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
7771: WHERE tp.sr_tp_id= msi.organization_id
7772: AND tp.sr_instance_id= msi.sr_instance_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,
7877: msc_supplies s
7878: WHERE /*
7879: ( md.SUBST_ITEM_FLAG <> 1
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,
7991: msc_supplies s
7992: WHERE /*not exists (select 'x'
7993: from msc_exception_details excp
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
8119: WHERE tp.sr_tp_id= msi.organization_id
8120: AND tp.sr_instance_id= msi.sr_instance_id
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,
8570: msc_plan_organizations_v orgs