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: APPS.FINANCIALS_PURGES_V

Object Details

Object Name:	FINANCIALS_PURGES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.FINANCIALS_PURGES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
ACTION	VARCHAR2	(25)	Yes
ACTIVITY_DATE	DATE
AP_BATCHES	NUMBER
AP_CHECKS	NUMBER
AP_HOLDS	NUMBER
AP_INVOICES	NUMBER
AP_INVOICE_LINES	NUMBER
AP_INVOICE_DISTRIBUTIONS	NUMBER
AP_INVOICE_PAYMENTS	NUMBER
AP_INVOICE_PREPAYS	NUMBER
AP_PAYMENT_SCHEDULES	NUMBER
AP_RECURRING_PAYMENTS	NUMBER
AP_TRIAL_BALANCE	NUMBER
CATEGORY	VARCHAR2	(25)	Yes
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER		Yes
PO_ACCEPTANCES	NUMBER
PO_ACCRUAL_RECONCILE_TEMP	NUMBER
PO_APPROVALS	NUMBER
PO_BLANKET_ITEMS	NUMBER
PO_DELIVERIES	NUMBER
PO_DISTRIBUTIONS	NUMBER
PO_HEADERS	NUMBER
PO_HEADERS_ARCHIVE	NUMBER
PO_ITEM_HISTORY	NUMBER
PO_LINES	NUMBER
PO_LINES_ARCHIVE	NUMBER
PO_LINE_LOCATIONS	NUMBER
PO_LINE_LOCATIONS_ARCHIVE	NUMBER
PO_NOTES	NUMBER
PO_NOTE_REFERENCES	NUMBER
PO_NOTIFICATIONS	NUMBER
PO_QUALITY_INSPECTIONS	NUMBER
PO_RECEIPTS	NUMBER
PO_RECEIPT_HEADERS	NUMBER
PO_RELEASES	NUMBER
PO_REQUISITION_HEADERS	NUMBER
PO_REQUISITION_LINES	NUMBER
PO_REQ_DISTRIBUTIONS	NUMBER
PO_VENDORS	NUMBER
PO_VENDOR_CONTACTS	NUMBER
PO_VENDOR_LIST_ENTRIES	NUMBER
PO_VENDOR_LIST_HEADERS	NUMBER
PO_VENDOR_SITES	NUMBER
PURGE_NAME	VARCHAR2	(15)	Yes
STATUS	VARCHAR2	(25)	Yes
STATUS_DSP	VARCHAR2	(80)
DESCRPTION	VARCHAR2	(240)
CATEGORY_DSP	VARCHAR2	(80)
ACTION_DSP	VARCHAR2	(80)
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_ENCUMBRANCE_LINES	NUMBER
AP_PAYMENT_HISTORY	NUMBER
AP_MATCHED_RECT_ADJ	NUMBER
RCV_SUBLEDGER_DETAIL	NUMBER
AP_INV_APRVL_HIST	NUMBER
AP_LINE_APRVL_HIST	NUMBER
ORG_ID	NUMBER

Query Text

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


SELECT ROW_ID
,      ACTION
,      ACTIVITY_DATE
,      AP_BATCHES
,      AP_CHECKS
,      AP_HOLDS
,      AP_INVOICES
,      AP_INVOICE_LINES
,      AP_INVOICE_DISTRIBUTIONS
,      AP_INVOICE_PAYMENTS
,      AP_INVOICE_PREPAYS
,      AP_PAYMENT_SCHEDULES
,      AP_RECURRING_PAYMENTS
,      AP_TRIAL_BALANCE
,      CATEGORY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PO_ACCEPTANCES
,      PO_ACCRUAL_RECONCILE_TEMP
,      PO_APPROVALS
,      PO_BLANKET_ITEMS
,      PO_DELIVERIES
,      PO_DISTRIBUTIONS
,      PO_HEADERS
,      PO_HEADERS_ARCHIVE
,      PO_ITEM_HISTORY
,      PO_LINES
,      PO_LINES_ARCHIVE
,      PO_LINE_LOCATIONS
,      PO_LINE_LOCATIONS_ARCHIVE
,      PO_NOTES
,      PO_NOTE_REFERENCES
,      PO_NOTIFICATIONS
,      PO_QUALITY_INSPECTIONS
,      PO_RECEIPTS
,      PO_RECEIPT_HEADERS
,      PO_RELEASES
,      PO_REQUISITION_HEADERS
,      PO_REQUISITION_LINES
,      PO_REQ_DISTRIBUTIONS
,      PO_VENDORS
,      PO_VENDOR_CONTACTS
,      PO_VENDOR_LIST_ENTRIES
,      PO_VENDOR_LIST_HEADERS
,      PO_VENDOR_SITES
,      PURGE_NAME
,      STATUS
,      STATUS_DSP
,      DESCRPTION
,      CATEGORY_DSP
,      ACTION_DSP
,      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_ENCUMBRANCE_LINES
,      AP_PAYMENT_HISTORY
,      AP_MATCHED_RECT_ADJ
,      RCV_SUBLEDGER_DETAIL
,      AP_INV_APRVL_HIST
,      AP_LINE_APRVL_HIST
,      ORG_ID
FROM APPS.FINANCIALS_PURGES_V;

Dependencies

[top of page]

APPS.FINANCIALS_PURGES_V references the following:

APPS: AP_LOOKUP_CODES; FINANCIALS_PURGES_ALL; FND_GLOBAL - show dependent code; MO_GLOBAL - show dependent code

APPS.FINANCIALS_PURGES_V is not referenced by any database object