VIEW: APPS.FINANCIALS_PURGES_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)