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: PA.PA_TXN_INTERFACE_AUDIT_AR#

Object Details

Object Name:	PA_TXN_INTERFACE_AUDIT_AR#
Object Type:	VIEW
Owner:	PA
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PURGE_BATCH_ID	NUMBER		Yes
PURGE_RELEASE	VARCHAR2	(10)	Yes
PURGE_PROJECT_ID	NUMBER		Yes
ATTRIBUTE10	VARCHAR2	(150)
RAW_COST_RATE	NUMBER
INTERFACE_ID	NUMBER
UNMATCHED_NEGATIVE_TXN_FLAG	VARCHAR2	(1)
EXPENDITURE_ITEM_ID	NUMBER
ORG_ID	NUMBER
DR_CODE_COMBINATION_ID	NUMBER
CR_CODE_COMBINATION_ID	NUMBER
CDL_SYSTEM_REFERENCE1	VARCHAR2	(30)
CDL_SYSTEM_REFERENCE2	VARCHAR2	(30)
CDL_SYSTEM_REFERENCE3	VARCHAR2	(30)
GL_DATE	DATE
BURDENED_COST	NUMBER
BURDENED_COST_RATE	NUMBER
SYSTEM_LINKAGE	VARCHAR2	(30)
TXN_INTERFACE_ID	NUMBER		Yes
BEFORE_AFTER_FLAG	VARCHAR2	(1)	Yes
UPDATED_BY	NUMBER		Yes
UPDATE_DATE	DATE		Yes
USER_TRANSACTION_SOURCE	VARCHAR2	(80)
TRANSACTION_SOURCE	VARCHAR2	(30)	Yes
BATCH_NAME	VARCHAR2	(10)	Yes
EXPENDITURE_ENDING_DATE	DATE		Yes
EMPLOYEE_NUMBER	VARCHAR2	(30)
ORGANIZATION_NAME	VARCHAR2	(240)
EXPENDITURE_ITEM_DATE	DATE		Yes
PROJECT_NUMBER	VARCHAR2	(25)
TASK_NUMBER	VARCHAR2	(25)
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes
NON_LABOR_RESOURCE	VARCHAR2	(20)
NON_LABOR_RESOURCE_ORG_NAME	VARCHAR2	(240)
QUANTITY	NUMBER		Yes
RAW_COST	NUMBER
EXPENDITURE_COMMENT	VARCHAR2	(240)
TRANSACTION_STATUS_CODE	VARCHAR2	(2)	Yes
TRANSACTION_REJECTION_CODE	VARCHAR2	(30)
EXPENDITURE_ID	NUMBER
ORIG_TRANSACTION_REFERENCE	VARCHAR2	(50)	Yes
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
RECEIPT_CURRENCY_AMOUNT	NUMBER
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
RECEIPT_EXCHANGE_RATE	NUMBER
DENOM_CURRENCY_CODE	VARCHAR2	(15)
DENOM_RAW_COST	NUMBER
DENOM_BURDENED_COST	NUMBER
ACCT_RATE_TYPE	VARCHAR2	(30)
ACCT_RATE_DATE	DATE
ACCT_EXCHANGE_RATE	NUMBER
ACCT_RAW_COST	NUMBER
ACCT_BURDENED_COST	NUMBER
ACCT_EXCHANGE_ROUNDING_LIMIT	NUMBER
PROJECT_CURRENCY_CODE	VARCHAR2	(15)
PROJECT_RATE_TYPE	VARCHAR2	(30)
PROJECT_RATE_DATE	DATE
PROJECT_EXCHANGE_RATE	NUMBER
ORIG_EXP_TXN_REFERENCE1	VARCHAR2	(60)
ORIG_EXP_TXN_REFERENCE2	VARCHAR2	(60)
ORIG_EXP_TXN_REFERENCE3	VARCHAR2	(60)
ORIG_USER_EXP_TXN_REFERENCE	VARCHAR2	(60)
OVERRIDE_TO_ORGANIZATION_NAME	VARCHAR2	(240)
REVERSED_ORIG_TXN_REFERENCE	VARCHAR2	(30)
VENDOR_NUMBER	VARCHAR2	(30)
BILLABLE_FLAG	VARCHAR2	(1)
PERSON_BUSINESS_GROUP_NAME	VARCHAR2	(240)
PROJFUNC_CURRENCY_CODE	VARCHAR2	(15)
PROJFUNC_COST_RATE_TYPE	VARCHAR2	(30)
PROJFUNC_COST_RATE_DATE	DATE
PROJFUNC_COST_EXCHANGE_RATE	NUMBER
PROJECT_RAW_COST	NUMBER
PROJECT_BURDENED_COST	NUMBER
ASSIGNMENT_NAME	VARCHAR2	(80)
WORK_TYPE_NAME	VARCHAR2	(80)
CDL_SYSTEM_REFERENCE4	VARCHAR2	(30)
ACCRUAL_FLAG	VARCHAR2	(1)
PROJECT_ID	NUMBER	(15)
TASK_ID	NUMBER	(15)
PERSON_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)
NON_LABOR_RESOURCE_ORG_ID	NUMBER	(15)
VENDOR_ID	NUMBER	(15)
OVERRIDE_TO_ORGANIZATION_ID	NUMBER	(15)
ASSIGNMENT_ID	NUMBER	(15)
WORK_TYPE_ID	NUMBER
PERSON_BUSINESS_GROUP_ID	NUMBER	(15)
PO_NUMBER	VARCHAR2	(20)
PO_HEADER_ID	NUMBER
PO_LINE_NUM	NUMBER
PO_LINE_ID	NUMBER
PERSON_TYPE	VARCHAR2	(30)
PO_PRICE_TYPE	VARCHAR2	(30)
UNIT_OF_MEASURE	VARCHAR2	(30)
WIP_RESOURCE_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER
CDL_SYSTEM_REFERENCE5	NUMBER	(15)
FC_DOCUMENT_TYPE	VARCHAR2	(3)
ADJUSTED_EXPENDITURE_ITEM_ID	NUMBER	(15)
ADJUSTED_TXN_INTERFACE_ID	NUMBER	(15)
DOCUMENT_TYPE	VARCHAR2	(30)
DOCUMENT_DISTRIBUTION_TYPE	VARCHAR2	(30)
SI_ASSETS_ADDITION_FLAG	VARCHAR2	(1)
NET_ZERO_ADJUSTMENT_FLAG	VARCHAR2	(1)
SC_XFER_CODE	VARCHAR2	(1)
JOB_ID	NUMBER	(15)
JOB_NAME	VARCHAR2	(700)
LOCATION_ID	NUMBER	(15)
LOCATION_CODE	VARCHAR2	(20)
PAY_ELEMENT_TYPE_ID	NUMBER	(9)
CBS_ELEMENT_ID	NUMBER	(15)
CBS_ELEMENT_NAME	VARCHAR2	(250)

Query Text

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


SELECT PURGE_BATCH_ID
,      PURGE_RELEASE
,      PURGE_PROJECT_ID
,      ATTRIBUTE10
,      RAW_COST_RATE
,      INTERFACE_ID
,      UNMATCHED_NEGATIVE_TXN_FLAG
,      EXPENDITURE_ITEM_ID
,      ORG_ID
,      DR_CODE_COMBINATION_ID
,      CR_CODE_COMBINATION_ID
,      CDL_SYSTEM_REFERENCE1
,      CDL_SYSTEM_REFERENCE2
,      CDL_SYSTEM_REFERENCE3
,      GL_DATE
,      BURDENED_COST
,      BURDENED_COST_RATE
,      SYSTEM_LINKAGE
,      TXN_INTERFACE_ID
,      BEFORE_AFTER_FLAG
,      UPDATED_BY
,      UPDATE_DATE
,      USER_TRANSACTION_SOURCE
,      TRANSACTION_SOURCE
,      BATCH_NAME
,      EXPENDITURE_ENDING_DATE
,      EMPLOYEE_NUMBER
,      ORGANIZATION_NAME
,      EXPENDITURE_ITEM_DATE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      EXPENDITURE_TYPE
,      NON_LABOR_RESOURCE
,      NON_LABOR_RESOURCE_ORG_NAME
,      QUANTITY
,      RAW_COST
,      EXPENDITURE_COMMENT
,      TRANSACTION_STATUS_CODE
,      TRANSACTION_REJECTION_CODE
,      EXPENDITURE_ID
,      ORIG_TRANSACTION_REFERENCE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      RECEIPT_CURRENCY_AMOUNT
,      RECEIPT_CURRENCY_CODE
,      RECEIPT_EXCHANGE_RATE
,      DENOM_CURRENCY_CODE
,      DENOM_RAW_COST
,      DENOM_BURDENED_COST
,      ACCT_RATE_TYPE
,      ACCT_RATE_DATE
,      ACCT_EXCHANGE_RATE
,      ACCT_RAW_COST
,      ACCT_BURDENED_COST
,      ACCT_EXCHANGE_ROUNDING_LIMIT
,      PROJECT_CURRENCY_CODE
,      PROJECT_RATE_TYPE
,      PROJECT_RATE_DATE
,      PROJECT_EXCHANGE_RATE
,      ORIG_EXP_TXN_REFERENCE1
,      ORIG_EXP_TXN_REFERENCE2
,      ORIG_EXP_TXN_REFERENCE3
,      ORIG_USER_EXP_TXN_REFERENCE
,      OVERRIDE_TO_ORGANIZATION_NAME
,      REVERSED_ORIG_TXN_REFERENCE
,      VENDOR_NUMBER
,      BILLABLE_FLAG
,      PERSON_BUSINESS_GROUP_NAME
,      PROJFUNC_CURRENCY_CODE
,      PROJFUNC_COST_RATE_TYPE
,      PROJFUNC_COST_RATE_DATE
,      PROJFUNC_COST_EXCHANGE_RATE
,      PROJECT_RAW_COST
,      PROJECT_BURDENED_COST
,      ASSIGNMENT_NAME
,      WORK_TYPE_NAME
,      CDL_SYSTEM_REFERENCE4
,      ACCRUAL_FLAG
,      PROJECT_ID
,      TASK_ID
,      PERSON_ID
,      ORGANIZATION_ID
,      NON_LABOR_RESOURCE_ORG_ID
,      VENDOR_ID
,      OVERRIDE_TO_ORGANIZATION_ID
,      ASSIGNMENT_ID
,      WORK_TYPE_ID
,      PERSON_BUSINESS_GROUP_ID
,      PO_NUMBER
,      PO_HEADER_ID
,      PO_LINE_NUM
,      PO_LINE_ID
,      PERSON_TYPE
,      PO_PRICE_TYPE
,      UNIT_OF_MEASURE
,      WIP_RESOURCE_ID
,      INVENTORY_ITEM_ID
,      CDL_SYSTEM_REFERENCE5
,      FC_DOCUMENT_TYPE
,      ADJUSTED_EXPENDITURE_ITEM_ID
,      ADJUSTED_TXN_INTERFACE_ID
,      DOCUMENT_TYPE
,      DOCUMENT_DISTRIBUTION_TYPE
,      SI_ASSETS_ADDITION_FLAG
,      NET_ZERO_ADJUSTMENT_FLAG
,      SC_XFER_CODE
,      JOB_ID
,      JOB_NAME
,      LOCATION_ID
,      LOCATION_CODE
,      PAY_ELEMENT_TYPE_ID
,      CBS_ELEMENT_ID
,      CBS_ELEMENT_NAME
FROM PA.PA_TXN_INTERFACE_AUDIT_AR#;

Dependencies

[top of page]

PA.PA_TXN_INTERFACE_AUDIT_AR# references the following:

PA: PA_TXN_INTERFACE_AUDIT_AR

PA.PA_TXN_INTERFACE_AUDIT_AR# is referenced by following:

APPS: PA_TXN_INTERFACE_AUDIT_AR