eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: AP.FINANCIALS_PURGES_ALL#

Object Details

Object Name:	FINANCIALS_PURGES_ALL#
Object Type:	VIEW
Owner:	AP
Subobject Name:
Status:	VALID

[View Source]

Columns

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

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AP.FINANCIALS_PURGES_ALL# references the following:

AP: FINANCIALS_PURGES_ALL

AP.FINANCIALS_PURGES_ALL# is referenced by following:

APPS: FINANCIALS_PURGES; FINANCIALS_PURGES_ALL