NEW ALL P2P CYCLE TABLES

SELECT *
  FROM mtl_system_items_b
 WHERE segment1 = 'Sony Vaio Laptop'


SELECT *
  FROM po_requisition_headers_all
 WHERE segment1 = '14693'


SELECT *
  FROM po_requisition_lines_all
 WHERE requisition_header_id = 182124


SELECT *
  FROM po_req_distributions_all
 WHERE requisition_line_id = 209330
 

SELECT *
  FROM gl_code_combinations
 WHERE code_combination_id = 12854--13401


SELECT *
  FROM po_headers_all
 WHERE segment1 = '333' AND type_lookup_code = 'RFQ'


SELECT *
  FROM po_lines_all
 WHERE po_header_id = 111380


SELECT *
  FROM po_headers_all
 WHERE segment1 = '536' AND type_lookup_code = 'QUOTATION'


SELECT *
  FROM po_lines_all
 WHERE po_header_id = 111387

---STATUS_LOOKUP_CODE tO iDENTIFY THE STATUS OF THE QUOTATION ----


SELECT *
  FROM po_headers_all
 WHERE segment1 = '535' AND type_lookup_code = 'QUOTATION'


SELECT *
  FROM po_lines_all
 WHERE po_header_id = 111382


SELECT AUTHORIZATION_STATUS
  FROM po_headers_all
 WHERE segment1 = '6525'


SELECT *
  FROM po_lines_all
 WHERE po_header_id = 111388


SELECT *
  FROM po_line_locations_all
 WHERE po_line_id = 174294


SELECT *
  FROM po_distributions_all
 WHERE po_header_id = 111388
   AND po_line_id = 174294
   AND line_location_id = 265640


SELECT *
  FROM ap_supplier_sites_all
 WHERE vendor_site_id = 1414 AND vendor_id = 600


SELECT *
  FROM ap_suppliers
 WHERE vendor_id = 600


SELECT *
  FROM ap_supplier_contacts
 WHERE vendor_contact_id = 953 AND vendor_site_id = 1414 


SELECT *
  FROM hr_locations_all
 WHERE ship_to_location_id = 207


SELECT *
  FROM hr_locations_all
 WHERE location_id = 26616 


SELECT *
  FROM hr_locations_all
 WHERE location_code = 'V1- New York City'


SELECT *
  FROM rcv_shipment_headers
  WHERE RECEIPT_NUM = '23853'     --'8540'
  AND TRUNC (creation_date) = TRUNC (SYSDATE)          


SELECT *
  FROM rcv_shipment_lines
 WHERE shipment_header_id = 4849936


SELECT *
  FROM rcv_transactions
 WHERE shipment_header_id = 4849936 AND shipment_line_id = 4843497  
 
 
SELECT *
  FROM ap_invoices_all
 WHERE invoice_num = '27/02/11'


SELECT *
  FROM ap_invoice_lines_all
 WHERE invoice_id = 212380


SELECT *
  FROM ap_invoice_distributions_all
 WHERE po_distribution_id = 272016  AND rcv_transaction_id = 4931419

SELECT *
  FROM gl_je_headers
 WHERE NAME = 'Feb-11 Purchase Invoices USD'
   AND description = 'Journal Import 5834577:'


SELECT *
  FROM gl_je_lines
 WHERE je_header_id = 4712215


SELECT *
  FROM gl_je_lines
 WHERE je_header_id = 4712216


SELECT *
  FROM gl_je_batches
 WHERE je_batch_id = 2958241


SELECT *
  FROM gl_je_batches
 WHERE je_batch_id = 2958233 





SELECT *
  FROM ap_invoice_payments_all
 WHERE invoice_id = 212380


SELECT *
  FROM ap_payment_distributions_all
 WHERE TRUNC (creation_date) = TRUNC (SYSDATE)


SELECT *
  FROM ap_checks_all
 WHERE check_number = 10050 AND currency_code = 'USD'


SELECT *
  FROM ap_payment_schedules_all
 WHERE invoice_id = 212380


SELECT *
  FROM ap_payment_history_all
 WHERE check_id = 78221


SELECT *
  FROM gl_je_headers
 WHERE NAME = 'Feb-11 Payments USD'
       AND description = 'Journal Import 5834372:'
       
SELECT * FROM PER_ALL_PEOPLE_F WHERE PERSON_ID = 25