View: FINANCIALS_PURGES_V

Product:	AP - Payables
Description:	(Release 10SC Only)
Implementation/DBA Data:	APPS.FINANCIALS_PURGES_V

View Text

SELECT FP.ROWID ROW_ID
, FP.ACTION ACTION
, FP.ACTIVITY_DATE ACTIVITY_DATE
, FP.AP_BATCHES AP_BATCHES
, FP.AP_CHECKS AP_CHECKS
, FP.AP_HOLDS AP_HOLDS
, FP.AP_INVOICES AP_INVOICES
, FP.AP_INVOICE_LINES AP_INVOICE_LINES
, FP.AP_INVOICE_DISTRIBUTIONS AP_INVOICE_DISTRIBUTIONS
, FP.AP_INVOICE_PAYMENTS AP_INVOICE_PAYMENTS
, FP.AP_INVOICE_PREPAYS AP_INVOICE_PREPAYS
, FP.AP_PAYMENT_SCHEDULES AP_PAYMENT_SCHEDULES
, FP.AP_RECURRING_PAYMENTS AP_RECURRING_PAYMENTS
, FP.AP_TRIAL_BALANCE AP_TRIAL_BALANCE
, FP.CATEGORY CATEGORY
, FP.CREATED_BY CREATED_BY
, FP.CREATION_DATE CREATION_DATE
, FP.LAST_UPDATED_BY LAST_UPDATED_BY
, FP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FP.PO_ACCEPTANCES PO_ACCEPTANCES
, FP.PO_ACCRUAL_RECONCILE_TEMP PO_ACCRUAL_RECONCILE_TEMP
, FP.PO_APPROVALS PO_APPROVALS
, FP.PO_BLANKET_ITEMS PO_BLANKET_ITEMS
, FP.PO_DELIVERIES PO_DELIVERIES
, FP.PO_DISTRIBUTIONS PO_DISTRIBUTIONS
, FP.PO_HEADERS PO_HEADERS
, FP.PO_HEADERS_ARCHIVE PO_HEADERS_ARCHIVE
, FP.PO_ITEM_HISTORY PO_ITEM_HISTORY
, FP.PO_LINES PO_LINES
, FP.PO_LINES_ARCHIVE PO_LINES_ARCHIVE
, FP.PO_LINE_LOCATIONS PO_LINE_LOCATIONS
, FP.PO_LINE_LOCATIONS_ARCHIVE PO_LINE_LOCATIONS_ARCHIVE
, FP.PO_NOTES PO_NOTES
, FP.PO_NOTE_REFERENCES PO_NOTE_REFERENCES
, FP.PO_NOTIFICATIONS PO_NOTIFICATIONS
, FP.PO_QUALITY_INSPECTIONS PO_QUALITY_INSPECTIONS
, FP.PO_RECEIPTS PO_RECEIPTS
, FP.PO_RECEIPT_HEADERS PO_RECEIPT_HEADERS
, FP.PO_RELEASES PO_RELEASES
, FP.PO_REQUISITION_HEADERS PO_REQUISITION_HEADERS
, FP.PO_REQUISITION_LINES PO_REQUISITION_LINES
, FP.PO_REQ_DISTRIBUTIONS PO_REQ_DISTRIBUTIONS
, FP.PO_VENDORS PO_VENDORS
, FP.PO_VENDOR_CONTACTS PO_VENDOR_CONTACTS
, FP.PO_VENDOR_LIST_ENTRIES PO_VENDOR_LIST_ENTRIES
, FP.PO_VENDOR_LIST_HEADERS PO_VENDOR_LIST_HEADERS
, FP.PO_VENDOR_SITES PO_VENDOR_SITES
, FP.PURGE_NAME PURGE_NAME
, FP.STATUS STATUS
, ALC1.DISPLAYED_FIELD STATUS_DSP
, ALC1.DESCRIPTION DESCRPTION
, ALC2.DISPLAYED_FIELD CATEGORY_DSP
, ALC3.DISPLAYED_FIELD ACTION_DSP
, FP.ORGANIZATION_ID
, FP.PO_APPROVED_SUPPLIER_LIST
, FP.PO_ASL_ATTRIBUTES
, FP.PO_ASL_DOCUMENTS
, FP.CHV_AUTHORIZATIONS
, FP.CHV_CUM_ADJUSTMENTS
, FP.CHV_CUM_PERIODS
, FP.CHV_CUM_PERIOD_ITEMS
, FP.CHV_HORIZONTAL_SCHEDULES
, FP.CHV_ITEM_ORDERS
, FP.CHV_SCHEDULE_HEADERS
, FP.CHV_SCHEDULE_ITEMS
, FP.MRP_SR_SOURCE_ORG
, FP.MRP_ITEM_SOURCING
, FP.AP_ACCOUNTING_EVENTS
, FP.AP_AE_HEADERS
, FP.AP_AE_LINES
, FP.AP_ENCUMBRANCE_LINES
, FP.AP_PAYMENT_HISTORY
, FP.AP_MATCHED_RECT_ADJ
, FP.RCV_SUBLEDGER_DETAILS
, FP.AP_INV_APRVL_HIST AP_INV_APRVL_HIST
, FP.AP_LINE_APRVL_HIST AP_LINE_APRVL_HIST
, FP.ORG_ID
, FP.APPROX_ROWS
, FP.PAY_ALONE
FROM FINANCIALS_PURGES_ALL FP
, AP_LOOKUP_CODES ALC1
, AP_LOOKUP_CODES ALC2
, AP_LOOKUP_CODES ALC3
WHERE ALC1.LOOKUP_TYPE(+) = 'PURGE STATUS'
AND ALC1.LOOKUP_CODE(+) = FP.STATUS
AND ALC2.LOOKUP_TYPE(+) = 'PURGE CATEGORY'
AND ALC2.LOOKUP_CODE(+) = FP.CATEGORY
AND ALC3.LOOKUP_TYPE(+) = 'PURGE ACTION'
AND ALC3.LOOKUP_CODE(+) = FP.ACTION
AND (MO_GLOBAL.CHECK_ACCESS(FP.ORG_ID) = 'Y' OR FP.ORG_ID IS NULL)

Columns