REQUISITIONS: SELECT * FROM PO_REQUISITION_HEADERS_ALL WHERE TYPE_LOOKUP_CODE='PURCHASE' AND TRUNC (CREATION_DATE) =TRUNC (SYSDATE) SELECT * FROM PO_REQUISITION_LINES_ALL WHERE TRUNC(CREATION_DATE)=TRUNC(SYSDATE) SELECT * FROM PO_REQ_DISTRIBUTIONS_ALL WHERE TRUNC(CREATION_DATE)=TRUNC(SYSDATE)
RFQ SELECT * FROM PO_HEADERS_ALL WHERE TYPE_LOOKUP_CODE='RFQ' AND QUOTE_TYPE_LOOKUP_CODE='BID' AND TRUNC(CREATION_DATE)=TRUNC(SYSDATE) SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=110306 SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_HEADER_ID=110306
QUOTATION SELECT * FROM PO_HEADERS_ALL WHERE TYPE_LOOKUP_CODE='QUOTATION' AND QUOTE_TYPE_LOOKUP_CODE='BID' AND TRUNC(CREATION_DATE)=TRUNC(SYSDATE) SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=110307 SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_HEADER_ID=110307
PURCHASE ORDER SELECT * FROM PO_HEADERS_ALL WHERE TYPE_LOOKUP_CODE='STANDARD' AND SEGMENT1='6025' SELECT * FROM PO_LINES_ALL WHERE PO_HEADER_ID=110308 SELECT * FROM PO_LINE_LOCATIONS_ALL WHERE PO_HEADER_ID=110308 SELECT * FROM PO_DISTRIBUTIONS_ALL WHERE PO_HEADER_ID=110308
INVOICES SELECT * FROM AP_INVOICES_ALL WHERE INVOICE_NUM='1234' SELECT * FROM AP_INVOICE_LINES_ALL WHERE INVOICE_ID=211300 SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE PO_DISTRIBUTION_ID IN(270850,270851) (OR) SELECT * FROM AP_INVOICE_DISTRIBUTIONS_ALL WHERE INVOICE_ID=211300
PAYMENT SELECT * FROM AP_INVOICE_PAYMENTS_ALL WHERE INVOICE_ID=211300 SELECT * FROM AP_PAYMENT_SCHEDULES_ALL WHERE INVOICE_ID=211300 SELECT * FROM AP_CHECKS_ALL WHERE CHECK_NUMBER=6396 SELECT * FROM AP_CHECK_FORMATS SELECT * FROM AP_PAYMENT_HISTORY_ALL WHERE CHECK_ID=77530 SELECT * FROM AP_BANK_ACCOUNTS_ALL SELECT * FROM AP_BANK_BRANCHES SELECT * FROM AP_TERMS_TL WHERE TERM_ID='10002' SELECT * FROM AP_TERMS_LINES WHERE TERM_ID='10002' SELECT * FROM AP_HOLDS_ALL