Query

  • October 2019
  • PDF

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')))

Related Documents

Query
October 2019 37
Query
November 2019 32
Query
October 2019 34
Query
October 2019 31
Query
November 2019 27
Query
December 2019 14