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

TABLE: AP.FINANCIALS_PURGES_ALL

Object Details
Object Name: FINANCIALS_PURGES_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.FINANCIALS_PURGES_ALL
Subobject Name:
Status: VALID


FINANCIALS_PURGES stores the criteria that your Oracle
Payables application uses to select invoices to purge.
Your Oracle Payables application inserts one row each
time you submit the purge process. Your Oracle
Payables application also stores statistical
information on the number of records it deletes from
each table when you confirm an invoice purge.
Values for STATUS may be 'INITIATE', 'PRINTED',
'DELETING', 'CONFIRM', 'ABORT', 'COMPLETED-ABORTED',
and 'COMPLETED-PURGED'.
This table corresponds to the Submit Purge form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
PURGE_NAME VARCHAR2 (15) Yes Name of purge
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER
Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CATEGORY VARCHAR2 (25) Yes Type of purge process
STATUS VARCHAR2 (25) Yes Status of completion of purge process
ACTION VARCHAR2 (25) Yes Action you select for purge
ACTIVITY_DATE DATE

Last date record updated (Records updated on or before this date will be selected as purge candidates)
AP_CHECKS NUMBER

Number of rows purged from this table
AP_INVOICES NUMBER

Number of rows purged from this table
PO_REQUISITION_HEADERS NUMBER

Number of rows purged from this table
PO_HEADERS NUMBER

Number of rows purged from this table
PO_VENDORS NUMBER

Number of rows purged from this table
AP_INVOICE_PAYMENTS NUMBER

Number of rows purged from this table
AP_INVOICE_PREPAYS NUMBER

Number of rows purged from this table
AP_PAYMENT_SCHEDULES NUMBER

Number of rows purged from this table
AP_RECURRING_PAYMENTS NUMBER

Number of rows purged from this table
AP_TRIAL_BALANCE NUMBER

Number of rows purged from this table
AP_INVOICE_DISTRIBUTIONS NUMBER

Number of rows purged from this table
AP_HOLDS NUMBER

Number of rows purged from this table
AP_BATCHES NUMBER

Number of rows purged from this table
PO_REQUISITION_LINES NUMBER

Number of rows purged from this table
PO_REQ_DISTRIBUTIONS NUMBER

Number of rows purged from this table
PO_APPROVALS NUMBER

Number of rows purged from this table
PO_LINES NUMBER

Number of rows purged from this table
PO_LINE_LOCATIONS NUMBER

Number of rows purged from this table
PO_DISTRIBUTIONS NUMBER

Number of rows purged from this table
PO_RELEASES NUMBER

Number of rows purged from this table
PO_ITEM_HISTORY NUMBER

Number of rows purged from this table
PO_ACCEPTANCES NUMBER

Number of rows purged from this table
PO_NOTES NUMBER

Number of rows purged from this table
PO_NOTE_REFERENCES NUMBER

Number of rows purged from this table
PO_RECEIPTS NUMBER

Number of rows purged from this table
PO_DELIVERIES NUMBER

Number of rows purged from this table
PO_QUALITY_INSPECTIONS NUMBER

Number of rows purged from this table
PO_VENDOR_SITES NUMBER

Number of rows purged from this table
PO_VENDOR_CONTACTS NUMBER

Number of rows purged from this table
PO_HEADERS_ARCHIVE NUMBER

Number of rows purged from this table
PO_LINES_ARCHIVE NUMBER

Number of rows purged from this table
PO_LINE_LOCATIONS_ARCHIVE NUMBER

Number of rows purged from this table
PO_VENDOR_LIST_HEADERS NUMBER

Number of rows purged from this table
PO_VENDOR_LIST_ENTRIES NUMBER

Number of rows purged from this table
PO_NOTIFICATIONS NUMBER

Number of rows purged from this table
PO_ACCRUAL_RECONCILE_TEMP NUMBER

Number of rows purged from this table
PO_BLANKET_ITEMS NUMBER

Number of rows purged from this table
PO_RECEIPT_HEADERS NUMBER

Number of rows purged from this table
ORGANIZATION_ID NUMBER

Organization identifier
PO_APPROVED_SUPPLIER_LIST NUMBER

Number of rows purged from this table
PO_ASL_ATTRIBUTES NUMBER

Number of rows purged from this table
PO_ASL_DOCUMENTS NUMBER

Number of rows purged from this table
CHV_AUTHORIZATIONS NUMBER

Number of rows purged from this table
CHV_CUM_ADJUSTMENTS NUMBER

Number of rows purged from this table
CHV_CUM_PERIODS NUMBER

Number of rows purged from this table
CHV_CUM_PERIOD_ITEMS NUMBER

Number of rows purged from this table
CHV_HORIZONTAL_SCHEDULES NUMBER

Number of rows purged from this table
CHV_ITEM_ORDERS NUMBER

Number of rows purged from this table
CHV_SCHEDULE_HEADERS NUMBER

Number of rows purged from this table
CHV_SCHEDULE_ITEMS NUMBER

Number of rows purged from this table
MRP_SR_SOURCE_ORG NUMBER

Number of rows purged from this table
MRP_ITEM_SOURCING NUMBER

Number of rows purged from this table
AP_ACCOUNTING_EVENTS NUMBER

Number of records purged from same name table
AP_AE_HEADERS NUMBER

Number of records purged from same name table
AP_AE_LINES NUMBER

Number of records purged from same name table
AP_CHRG_ALLOCATIONS NUMBER

Number of records purged from same name table
AP_ENCUMBRANCE_LINES NUMBER

Number of records purged from same name table
AP_PAYMENT_HISTORY NUMBER

Number of records purged from same name table
AP_MATCHED_RECT_ADJ NUMBER

Number of records purged from same name table
RCV_SUBLEDGER_DETAILS NUMBER

Number of records purged from same name table
AP_MC_CHECKS NUMBER

Number of rows purged from this table
AP_MC_INVOICE_DISTS NUMBER

Number of rows purged from this table
AP_MC_INVOICE_PAYMENTS NUMBER

Number of rows purged from this table
AP_MC_INVOICES NUMBER

Number of rows purged from this table
PO_MC_DISTRIBUTIONS NUMBER

Number of rows purged from this table
PO_MC_HEADERS NUMBER

Number of rows purged from this table
ORG_ID NUMBER

Organization identifier
AP_INVOICE_LINES NUMBER

Number of rows purged from this table
AP_ALLOCATION_RULES NUMBER

Number of rows purged from this table
AP_ALLOCATION_RULE_LINES NUMBER

Number of rows purged from this table
AP_INV_APRVL_HIST NUMBER

Number of rows purged from this table
AP_LINE_APRVL_HIST NUMBER

Number of rows purged from this table
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
FROM AP.FINANCIALS_PURGES_ALL;

Dependencies

[top of page]

AP.FINANCIALS_PURGES_ALL does not reference any database object

AP.FINANCIALS_PURGES_ALL is referenced by following:

SchemaAPPS
SynonymFINANCIALS_PURGES
SynonymFINANCIALS_PURGES_ALL