Query
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Query as PDF for free.
More details
- Words: 72
- Pages: 1
select * from xxjn_scmc_to_oracle_buf@pscm
where quoteid = 'QT229686'
select * from xxjn_scmc_to_oracle_buf_arch where quoteid in ( 'QT229686' ) select * from en_coverage_type
where part_number = 'PAR-SUP-SA-SAMNC'
select serial_number from en_installed_product where oid in( select ins_product_oid from en_contract_detail where contract_oid in ( select oid from en_contract where contract_id in ('SUB27974', 'SUB26665')) ) select * from en_contract where oid in (select contract_oid from en_contract_detail where ins_product_oid in (select oid from en_installed_product where serial_number in('0064112003011267')))
where quoteid = 'QT229686'
select * from xxjn_scmc_to_oracle_buf_arch where quoteid in ( 'QT229686' ) select * from en_coverage_type
where part_number = 'PAR-SUP-SA-SAMNC'
select serial_number from en_installed_product where oid in( select ins_product_oid from en_contract_detail where contract_oid in ( select oid from en_contract where contract_id in ('SUB27974', 'SUB26665')) ) select * from en_contract where oid in (select contract_oid from en_contract_detail where ins_product_oid in (select oid from en_installed_product where serial_number in('0064112003011267')))
