Advertisement
psi_mmobile

Untitled

Feb 22nd, 2023
1,345
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.34 KB | None | 0 0
  1. SELECT *
  2. FROM person Person, subcontractor Subcontractor, attach_doc AttachDoc, vo_document_type VoDocumentType
  3. WHERE Person.RANK1_SC_TIN = Subcontractor.COMPANY_TIN
  4. AND AttachDoc.SUBCONTRACTOR_ID = Subcontractor.SUBCONTRACTOR_ID
  5. AND AttachDoc.vo_document_type_id = VoDocumentType.vo_document_type_id
  6. AND VoDocumentType.document_type_id = 102;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement