VIEW: AP.FINANCIALS_PURGES_ALL#

Source

View Text - Preformatted

select PURGE_NAME PURGE_NAME, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CATEGORY CATEGORY, STATUS STATUS, ACTION ACTION, ACTIVITY_DATE ACTIVITY_DATE, AP_CHECKS AP_CHECKS, AP_INVOICES AP_INVOICES, PO_REQUISITION_HEADERS PO_REQUISITION_HEADERS, PO_HEADERS PO_HEADERS, PO_VENDORS PO_VENDORS, AP_INVOICE_PAYMENTS AP_INVOICE_PAYMENTS, AP_INVOICE_PREPAYS AP_INVOICE_PREPAYS, AP_PAYMENT_SCHEDULES AP_PAYMENT_SCHEDULES, AP_RECURRING_PAYMENTS AP_RECURRING_PAYMENTS, AP_TRIAL_BALANCE AP_TRIAL_BALANCE, AP_INVOICE_DISTRIBUTIONS AP_INVOICE_DISTRIBUTIONS, AP_HOLDS AP_HOLDS, AP_BATCHES AP_BATCHES, PO_REQUISITION_LINES PO_REQUISITION_LINES, PO_REQ_DISTRIBUTIONS PO_REQ_DISTRIBUTIONS, PO_APPROVALS PO_APPROVALS, PO_LINES PO_LINES, PO_LINE_LOCATIONS PO_LINE_LOCATIONS, PO_DISTRIBUTIONS PO_DISTRIBUTIONS, PO_RELEASES PO_RELEASES, PO_ITEM_HISTORY PO_ITEM_HISTORY, PO_ACCEPTANCES PO_ACCEPTANCES, PO_NOTES PO_NOTES, PO_NOTE_REFERENCES PO_NOTE_REFERENCES, PO_RECEIPTS PO_RECEIPTS, PO_DELIVERIES PO_DELIVERIES, PO_QUALITY_INSPECTIONS PO_QUALITY_INSPECTIONS, PO_VENDOR_SITES PO_VENDOR_SITES, PO_VENDOR_CONTACTS PO_VENDOR_CONTACTS, PO_HEADERS_ARCHIVE PO_HEADERS_ARCHIVE, PO_LINES_ARCHIVE PO_LINES_ARCHIVE, PO_LINE_LOCATIONS_ARCHIVE PO_LINE_LOCATIONS_ARCHIVE, PO_VENDOR_LIST_HEADERS PO_VENDOR_LIST_HEADERS, PO_VENDOR_LIST_ENTRIES PO_VENDOR_LIST_ENTRIES, PO_NOTIFICATIONS PO_NOTIFICATIONS, PO_ACCRUAL_RECONCILE_TEMP PO_ACCRUAL_RECONCILE_TEMP, PO_BLANKET_ITEMS PO_BLANKET_ITEMS, PO_RECEIPT_HEADERS PO_RECEIPT_HEADERS, ORGANIZATION_ID ORGANIZATION_ID, PO_APPROVED_SUPPLIER_LIST PO_APPROVED_SUPPLIER_LIST, PO_ASL_ATTRIBUTES PO_ASL_ATTRIBUTES, PO_ASL_DOCUMENTS PO_ASL_DOCUMENTS, CHV_AUTHORIZATIONS CHV_AUTHORIZATIONS, CHV_CUM_ADJUSTMENTS CHV_CUM_ADJUSTMENTS, CHV_CUM_PERIODS CHV_CUM_PERIODS, CHV_CUM_PERIOD_ITEMS CHV_CUM_PERIOD_ITEMS, CHV_HORIZONTAL_SCHEDULES CHV_HORIZONTAL_SCHEDULES, CHV_ITEM_ORDERS CHV_ITEM_ORDERS, CHV_SCHEDULE_HEADERS CHV_SCHEDULE_HEADERS, CHV_SCHEDULE_ITEMS CHV_SCHEDULE_ITEMS, MRP_SR_SOURCE_ORG MRP_SR_SOURCE_ORG, MRP_ITEM_SOURCING MRP_ITEM_SOURCING, AP_ACCOUNTING_EVENTS AP_ACCOUNTING_EVENTS, AP_AE_HEADERS AP_AE_HEADERS, AP_AE_LINES AP_AE_LINES, AP_CHRG_ALLOCATIONS AP_CHRG_ALLOCATIONS, AP_ENCUMBRANCE_LINES AP_ENCUMBRANCE_LINES, AP_PAYMENT_HISTORY AP_PAYMENT_HISTORY, AP_MATCHED_RECT_ADJ AP_MATCHED_RECT_ADJ, RCV_SUBLEDGER_DETAILS RCV_SUBLEDGER_DETAILS, AP_MC_CHECKS AP_MC_CHECKS, AP_MC_INVOICE_DISTS AP_MC_INVOICE_DISTS, AP_MC_INVOICE_PAYMENTS AP_MC_INVOICE_PAYMENTS, AP_MC_INVOICES AP_MC_INVOICES, PO_MC_DISTRIBUTIONS PO_MC_DISTRIBUTIONS, PO_MC_HEADERS PO_MC_HEADERS, ORG_ID ORG_ID, AP_INVOICE_LINES AP_INVOICE_LINES, AP_ALLOCATION_RULES AP_ALLOCATION_RULES, AP_ALLOCATION_RULE_LINES AP_ALLOCATION_RULE_LINES, AP_INV_APRVL_HIST AP_INV_APRVL_HIST, AP_LINE_APRVL_HIST AP_LINE_APRVL_HIST, APPROX_ROWS APPROX_ROWS, PAY_ALONE PAY_ALONE from "AP"."FINANCIALS_PURGES_ALL"

View Text - HTML Formatted

SELECT PURGE_NAME PURGE_NAME
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CATEGORY CATEGORY
, STATUS STATUS
, ACTION ACTION
, ACTIVITY_DATE ACTIVITY_DATE
, AP_CHECKS AP_CHECKS
, AP_INVOICES AP_INVOICES
, PO_REQUISITION_HEADERS PO_REQUISITION_HEADERS
, PO_HEADERS PO_HEADERS
, PO_VENDORS PO_VENDORS
, AP_INVOICE_PAYMENTS AP_INVOICE_PAYMENTS
, AP_INVOICE_PREPAYS AP_INVOICE_PREPAYS
, AP_PAYMENT_SCHEDULES AP_PAYMENT_SCHEDULES
, AP_RECURRING_PAYMENTS AP_RECURRING_PAYMENTS
, AP_TRIAL_BALANCE AP_TRIAL_BALANCE
, AP_INVOICE_DISTRIBUTIONS AP_INVOICE_DISTRIBUTIONS
, AP_HOLDS AP_HOLDS
, AP_BATCHES AP_BATCHES
, PO_REQUISITION_LINES PO_REQUISITION_LINES
, PO_REQ_DISTRIBUTIONS PO_REQ_DISTRIBUTIONS
, PO_APPROVALS PO_APPROVALS
, PO_LINES PO_LINES
, PO_LINE_LOCATIONS PO_LINE_LOCATIONS
, PO_DISTRIBUTIONS PO_DISTRIBUTIONS
, PO_RELEASES PO_RELEASES
, PO_ITEM_HISTORY PO_ITEM_HISTORY
, PO_ACCEPTANCES PO_ACCEPTANCES
, PO_NOTES PO_NOTES
, PO_NOTE_REFERENCES PO_NOTE_REFERENCES
, PO_RECEIPTS PO_RECEIPTS
, PO_DELIVERIES PO_DELIVERIES
, PO_QUALITY_INSPECTIONS PO_QUALITY_INSPECTIONS
, PO_VENDOR_SITES PO_VENDOR_SITES
, PO_VENDOR_CONTACTS PO_VENDOR_CONTACTS
, PO_HEADERS_ARCHIVE PO_HEADERS_ARCHIVE
, PO_LINES_ARCHIVE PO_LINES_ARCHIVE
, PO_LINE_LOCATIONS_ARCHIVE PO_LINE_LOCATIONS_ARCHIVE
, PO_VENDOR_LIST_HEADERS PO_VENDOR_LIST_HEADERS
, PO_VENDOR_LIST_ENTRIES PO_VENDOR_LIST_ENTRIES
, PO_NOTIFICATIONS PO_NOTIFICATIONS
, PO_ACCRUAL_RECONCILE_TEMP PO_ACCRUAL_RECONCILE_TEMP
, PO_BLANKET_ITEMS PO_BLANKET_ITEMS
, PO_RECEIPT_HEADERS PO_RECEIPT_HEADERS
, ORGANIZATION_ID ORGANIZATION_ID
, PO_APPROVED_SUPPLIER_LIST PO_APPROVED_SUPPLIER_LIST
, PO_ASL_ATTRIBUTES PO_ASL_ATTRIBUTES
, PO_ASL_DOCUMENTS PO_ASL_DOCUMENTS
, CHV_AUTHORIZATIONS CHV_AUTHORIZATIONS
, CHV_CUM_ADJUSTMENTS CHV_CUM_ADJUSTMENTS
, CHV_CUM_PERIODS CHV_CUM_PERIODS
, CHV_CUM_PERIOD_ITEMS CHV_CUM_PERIOD_ITEMS
, CHV_HORIZONTAL_SCHEDULES CHV_HORIZONTAL_SCHEDULES
, CHV_ITEM_ORDERS CHV_ITEM_ORDERS
, CHV_SCHEDULE_HEADERS CHV_SCHEDULE_HEADERS
, CHV_SCHEDULE_ITEMS CHV_SCHEDULE_ITEMS
, MRP_SR_SOURCE_ORG MRP_SR_SOURCE_ORG
, MRP_ITEM_SOURCING MRP_ITEM_SOURCING
, AP_ACCOUNTING_EVENTS AP_ACCOUNTING_EVENTS
, AP_AE_HEADERS AP_AE_HEADERS
, AP_AE_LINES AP_AE_LINES
, AP_CHRG_ALLOCATIONS AP_CHRG_ALLOCATIONS
, AP_ENCUMBRANCE_LINES AP_ENCUMBRANCE_LINES
, AP_PAYMENT_HISTORY AP_PAYMENT_HISTORY
, AP_MATCHED_RECT_ADJ AP_MATCHED_RECT_ADJ
, RCV_SUBLEDGER_DETAILS RCV_SUBLEDGER_DETAILS
, AP_MC_CHECKS AP_MC_CHECKS
, AP_MC_INVOICE_DISTS AP_MC_INVOICE_DISTS
, AP_MC_INVOICE_PAYMENTS AP_MC_INVOICE_PAYMENTS
, AP_MC_INVOICES AP_MC_INVOICES
, PO_MC_DISTRIBUTIONS PO_MC_DISTRIBUTIONS
, PO_MC_HEADERS PO_MC_HEADERS
, ORG_ID ORG_ID
, AP_INVOICE_LINES AP_INVOICE_LINES
, AP_ALLOCATION_RULES AP_ALLOCATION_RULES
, AP_ALLOCATION_RULE_LINES AP_ALLOCATION_RULE_LINES
, AP_INV_APRVL_HIST AP_INV_APRVL_HIST
, AP_LINE_APRVL_HIST AP_LINE_APRVL_HIST
, APPROX_ROWS APPROX_ROWS
, PAY_ALONE PAY_ALONE
FROM "AP"."FINANCIALS_PURGES_ALL"