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.AP_PAYMENT_EXTRACT_DETAILS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
EVENT_ID	NUMBER	(15)	Yes
APHD_PAY_DIST_LOOKUP_CODE	VARCHAR2	(30)	Yes
LINE_NUMBER	NUMBER	(15)	Yes
DIST_ACCOUNT_REVERSAL_OPTION	VARCHAR2	(1)
APHD_REV_PAY_HIST_DIST_ID	NUMBER	(15)
THIRD_PARTY_TYPE	CHAR	(1)
AI_INVOICE_CURRENCY_CODE	VARCHAR2	(15)	Yes
APHD_REVERSAL_FLAG	VARCHAR2	(1)
APHD_AMOUNT	NUMBER		Yes
APHD_BANK_CURR_AMOUNT	NUMBER
APHD_HISTORICAL_FLAG	VARCHAR2	(1)
APHD_INVOICE_DIST_BASE_AMT	NUMBER
APHD_PAYMENT_HIST_DIST_ID	NUMBER	(15)	Yes
APHD_INVOICE_DISTRIBUTION_ID	NUMBER	(15)	Yes
APHD_PAYMENT_HISTORY_ID	NUMBER	(15)	Yes
APHD_INVOICE_PAYMENT_ID	NUMBER	(15)	Yes
INV_PMT_BASE_AMT_DIFF	NUMBER
PMT_MAT_BASE_AMT_DIFF	NUMBER
MAT_CLR_BASE_AMT_DIFF	NUMBER
PMT_CLR_BASE_AMT_DIFF	NUMBER
INV_CLR_BASE_AMT_DIFF	NUMBER
AIP_ACCOUNTING_DATE	DATE		Yes
AIP_AMOUNT	NUMBER		Yes
AIP_INVOICE_ID	NUMBER	(15)	Yes
AIP_INVOICE_PAYMENT_ID	NUMBER	(15)	Yes
AIP_PAYMENT_NUM	NUMBER	(15)	Yes
AIP_PERIOD_NAME	VARCHAR2	(15)	Yes
AIP_ACCTS_PAY_CCID	NUMBER	(15)
AIP_ASSET_CCID	NUMBER	(15)
AIP_ATTRIBUTE1	VARCHAR2	(150)
AIP_ATTRIBUTE10	VARCHAR2	(150)
AIP_ATTRIBUTE11	VARCHAR2	(150)
AIP_ATTRIBUTE12	VARCHAR2	(150)
AIP_ATTRIBUTE13	VARCHAR2	(150)
AIP_ATTRIBUTE14	VARCHAR2	(150)
AIP_ATTRIBUTE15	VARCHAR2	(150)
AIP_ATTRIBUTE2	VARCHAR2	(150)
AIP_ATTRIBUTE3	VARCHAR2	(150)
AIP_ATTRIBUTE4	VARCHAR2	(150)
AIP_ATTRIBUTE5	VARCHAR2	(150)
AIP_ATTRIBUTE6	VARCHAR2	(150)
AIP_ATTRIBUTE7	VARCHAR2	(150)
AIP_ATTRIBUTE8	VARCHAR2	(150)
AIP_ATTRIBUTE9	VARCHAR2	(150)
AIP_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
AIP_INVOICE_PAYMENT_TYPE	VARCHAR2	(25)
AIP_GLOBAL_ATTRIBUTE_CAT	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
AIP_GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
AIP_EXTERNAL_BANK_ACCOUNT_ID	NUMBER	(15)
AIP_ACCOUNTING_EVENT_ID	NUMBER	(15)
AIP_REVERSAL_FLAG	VARCHAR2	(1)
AIP_REVERSAL_INV_PMT_ID	NUMBER	(15)
AID_DIST_CCID	NUMBER	(15)	Yes
AID_AMOUNT	NUMBER
AID_AWT_FLAG	VARCHAR2	(1)
AID_LINE_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
AID_DISTRIBUTION_LINE_NUMBER	NUMBER	(15)	Yes
AWTG_NAME	VARCHAR2	(25)
AID_AWARD_ID	NUMBER	(15)
AID_RATE_VAR_CCID	NUMBER	(15)
AID_INVOICE_DIST_ID	NUMBER	(15)	Yes
AID_INCOME_TAX_REGION	VARCHAR2	(10)
AWT_AT_PMT_TIME	VARCHAR2	(1)
AID_MERCHANT_DOCUMENT_NUMBER	VARCHAR2	(80)
AID_MERCHANT_REFERENCE	VARCHAR2	(240)
AID_MERCHANT_TAXPAYER_ID	VARCHAR2	(80)
AID_MERCHANT_TAX_REG_NUMBER	VARCHAR2	(80)
AI_INVOICE_AMOUNT	NUMBER
AI_ACCTS_PAY_CCID	NUMBER	(15)
DISTRIBUTION_LINK_TYPE	CHAR	(11)
PO_DISTRIBUTION_ID	NUMBER	(15)
AWT_RELATED_DIST_ACCOUNT	NUMBER	(15)
AI_INVOICE_DATE	DATE
AI_INVOICE_TYPE_PAID	VARCHAR2	(25)
INV_DISCOUNT_AMOUNT_TAKEN	NUMBER
LEDGER_ID	NUMBER	(15)	Yes
INV_EXCHANGE_DATE	DATE
INV_EXCHANGE_RATE	NUMBER
INV_EXCHANGE_RATE_TYPE	VARCHAR2	(30)
APHD_INVOICE_DIST_AMOUNT	NUMBER
APHD_CLEARING_BASE_AMT	NUMBER
APHD_INVOICE_BASE_AMT	NUMBER
APHD_MATURED_BASE_AMOUNT	NUMBER
APHD_PAYMENT_BASE_AMT	NUMBER
INV_PMT_GAIN_LOSS_INDICATOR	VARCHAR2	(4)
INV_CLR_GAIN_LOSS_INDICATOR	VARCHAR2	(4)
PMT_MAT_GAIN_LOSS_INDICATOR	VARCHAR2	(4)
MAT_CLR_GAIN_LOSS_INDICATOR	VARCHAR2	(4)
PMT_CLR_GAIN_LOSS_INDICATOR	VARCHAR2	(4)
APHD_ROUNDING_AMT	NUMBER
APHD_PMT_BASE_NO_ROUND	NUMBER
APHD_CLEAR_BASE_AMT_NO_ROUND	NUMBER
APHD_MAT_BASE_AMT_NO_ROUND	NUMBER
BUS_FLOW_AP_APP_ID	NUMBER
BUS_FLOW_INV_DIST_TYPE	CHAR	(11)
BUS_FLOW_INV_ENTITY_CODE	CHAR	(11)
BUS_FLOW_INV_DIST_ID	NUMBER
BUS_FLOW_INV_ID	NUMBER	(15)	Yes
BUS_FLOW_PO_APP_ID	NUMBER
BUS_FLOW_PO_DIST_TYPE	CHAR	(7)
BUS_FLOW_PO_ENTITY_CODE	CHAR	(14)
BUS_FLOW_PAYMENT_DIST_TYPE	CHAR	(11)
BUS_FLOW_PAYMENT_ENTITY_CODE	CHAR	(11)
BUS_FLOW_PAYMENT_DIST_ID	NUMBER
BUS_FLOW_PAYMENT_ID	NUMBER	(15)	Yes
AID_PROJECT_ID	NUMBER	(15)
AID_TASK_ID	NUMBER	(15)
AID_EXPENDITURE_TYPE	VARCHAR2	(30)
AID_EXPENDITURE_ORG_ID	NUMBER	(15)
BF_RETAINED_INV_ID_PMT	NUMBER	(15)
BF_RETAINED_INV_DIST_ID_PMT	NUMBER	(15)
BF_RETAINED_INV_ID_CLR	NUMBER	(15)
BF_RETAINED_INV_DIST_ID_CLR	NUMBER	(15)
AID_RET_RELATED_DIST_CCID	NUMBER
AID_AWT_RELATED_ID	NUMBER	(15)
APHD_QUANTITY_VARIANCE	NUMBER
APHD_INV_BASE_QTY_VARIANCE	NUMBER
APHD_AMOUNT_VARIANCE	NUMBER
APHD_INV_BASE_AMT_VARIANCE	NUMBER
AID_DETAIL_TAX_DIST_ID	NUMBER
AID_ENCUMBERED_FLAG	VARCHAR2	(1)
POD_PO_DISTRIBUTION_ID	NUMBER
POD_ENCUMBERED_FLAG	VARCHAR2	(1)
POD_ENCUMBERED_AMOUNT	NUMBER
POD_GL_ENCUMBERED_DATE	DATE
POD_GL_ENCUMBERED_PERIOD_NAME	VARCHAR2	(15)
POD_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
POD_ATTRIBUTE1	VARCHAR2	(150)
POD_ATTRIBUTE2	VARCHAR2	(150)
POD_ATTRIBUTE3	VARCHAR2	(150)
POD_ATTRIBUTE4	VARCHAR2	(150)
POD_ATTRIBUTE5	VARCHAR2	(150)
POD_ATTRIBUTE6	VARCHAR2	(150)
POD_ATTRIBUTE7	VARCHAR2	(150)
POD_ATTRIBUTE8	VARCHAR2	(150)
POD_ATTRIBUTE9	VARCHAR2	(150)
POD_ATTRIBUTE10	VARCHAR2	(150)
POD_ATTRIBUTE11	VARCHAR2	(150)
POD_ATTRIBUTE12	VARCHAR2	(150)
POD_ATTRIBUTE13	VARCHAR2	(150)
POD_ATTRIBUTE14	VARCHAR2	(150)
POD_ATTRIBUTE15	VARCHAR2	(150)
POD_DISTRIBUTION_NUM	NUMBER
POD_ACCRUE_ON_RECEIPT_FLAG	VARCHAR2	(1)
POD_CCID	NUMBER
PO_VARIANCE_ACCOUNT	NUMBER
RELATED_INV_DIST_DEST_TYPE	VARCHAR2	(25)
POD_PO_HEADER_ID	NUMBER
POD_PO_LINE_ID	NUMBER
POD_LINE_LOCATION_ID	NUMBER
BUS_FLOW_PAYMENT_MAT_DIST_ID	NUMBER
OVERRIDE_ACCTD_AMT_FLAG	CHAR	(1)
AI_PAYMENT_STATUS_FLAG	VARCHAR2	(1)
ENCUMBRANCE_AMOUNT	NUMBER
AWT_RELATED_DIST_TYPE	VARCHAR2	(12)

Query Text

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


SELECT EVENT_ID
,      APHD_PAY_DIST_LOOKUP_CODE
,      LINE_NUMBER
,      DIST_ACCOUNT_REVERSAL_OPTION
,      APHD_REV_PAY_HIST_DIST_ID
,      THIRD_PARTY_TYPE
,      AI_INVOICE_CURRENCY_CODE
,      APHD_REVERSAL_FLAG
,      APHD_AMOUNT
,      APHD_BANK_CURR_AMOUNT
,      APHD_HISTORICAL_FLAG
,      APHD_INVOICE_DIST_BASE_AMT
,      APHD_PAYMENT_HIST_DIST_ID
,      APHD_INVOICE_DISTRIBUTION_ID
,      APHD_PAYMENT_HISTORY_ID
,      APHD_INVOICE_PAYMENT_ID
,      INV_PMT_BASE_AMT_DIFF
,      PMT_MAT_BASE_AMT_DIFF
,      MAT_CLR_BASE_AMT_DIFF
,      PMT_CLR_BASE_AMT_DIFF
,      INV_CLR_BASE_AMT_DIFF
,      AIP_ACCOUNTING_DATE
,      AIP_AMOUNT
,      AIP_INVOICE_ID
,      AIP_INVOICE_PAYMENT_ID
,      AIP_PAYMENT_NUM
,      AIP_PERIOD_NAME
,      AIP_ACCTS_PAY_CCID
,      AIP_ASSET_CCID
,      AIP_ATTRIBUTE1
,      AIP_ATTRIBUTE10
,      AIP_ATTRIBUTE11
,      AIP_ATTRIBUTE12
,      AIP_ATTRIBUTE13
,      AIP_ATTRIBUTE14
,      AIP_ATTRIBUTE15
,      AIP_ATTRIBUTE2
,      AIP_ATTRIBUTE3
,      AIP_ATTRIBUTE4
,      AIP_ATTRIBUTE5
,      AIP_ATTRIBUTE6
,      AIP_ATTRIBUTE7
,      AIP_ATTRIBUTE8
,      AIP_ATTRIBUTE9
,      AIP_ATTRIBUTE_CATEGORY
,      AIP_INVOICE_PAYMENT_TYPE
,      AIP_GLOBAL_ATTRIBUTE_CAT
,      AIP_GLOBAL_ATTRIBUTE1
,      AIP_GLOBAL_ATTRIBUTE2
,      AIP_GLOBAL_ATTRIBUTE3
,      AIP_GLOBAL_ATTRIBUTE4
,      AIP_GLOBAL_ATTRIBUTE5
,      AIP_GLOBAL_ATTRIBUTE6
,      AIP_GLOBAL_ATTRIBUTE7
,      AIP_GLOBAL_ATTRIBUTE8
,      AIP_GLOBAL_ATTRIBUTE9
,      AIP_GLOBAL_ATTRIBUTE10
,      AIP_GLOBAL_ATTRIBUTE11
,      AIP_GLOBAL_ATTRIBUTE12
,      AIP_GLOBAL_ATTRIBUTE13
,      AIP_GLOBAL_ATTRIBUTE14
,      AIP_GLOBAL_ATTRIBUTE15
,      AIP_GLOBAL_ATTRIBUTE16
,      AIP_GLOBAL_ATTRIBUTE17
,      AIP_GLOBAL_ATTRIBUTE18
,      AIP_GLOBAL_ATTRIBUTE19
,      AIP_GLOBAL_ATTRIBUTE20
,      AIP_EXTERNAL_BANK_ACCOUNT_ID
,      AIP_ACCOUNTING_EVENT_ID
,      AIP_REVERSAL_FLAG
,      AIP_REVERSAL_INV_PMT_ID
,      AID_DIST_CCID
,      AID_AMOUNT
,      AID_AWT_FLAG
,      AID_LINE_TYPE_LOOKUP_CODE
,      AID_DISTRIBUTION_LINE_NUMBER
,      AWTG_NAME
,      AID_AWARD_ID
,      AID_RATE_VAR_CCID
,      AID_INVOICE_DIST_ID
,      AID_INCOME_TAX_REGION
,      AWT_AT_PMT_TIME
,      AID_MERCHANT_DOCUMENT_NUMBER
,      AID_MERCHANT_REFERENCE
,      AID_MERCHANT_TAXPAYER_ID
,      AID_MERCHANT_TAX_REG_NUMBER
,      AI_INVOICE_AMOUNT
,      AI_ACCTS_PAY_CCID
,      DISTRIBUTION_LINK_TYPE
,      PO_DISTRIBUTION_ID
,      AWT_RELATED_DIST_ACCOUNT
,      AI_INVOICE_DATE
,      AI_INVOICE_TYPE_PAID
,      INV_DISCOUNT_AMOUNT_TAKEN
,      LEDGER_ID
,      INV_EXCHANGE_DATE
,      INV_EXCHANGE_RATE
,      INV_EXCHANGE_RATE_TYPE
,      APHD_INVOICE_DIST_AMOUNT
,      APHD_CLEARING_BASE_AMT
,      APHD_INVOICE_BASE_AMT
,      APHD_MATURED_BASE_AMOUNT
,      APHD_PAYMENT_BASE_AMT
,      INV_PMT_GAIN_LOSS_INDICATOR
,      INV_CLR_GAIN_LOSS_INDICATOR
,      PMT_MAT_GAIN_LOSS_INDICATOR
,      MAT_CLR_GAIN_LOSS_INDICATOR
,      PMT_CLR_GAIN_LOSS_INDICATOR
,      APHD_ROUNDING_AMT
,      APHD_PMT_BASE_NO_ROUND
,      APHD_CLEAR_BASE_AMT_NO_ROUND
,      APHD_MAT_BASE_AMT_NO_ROUND
,      BUS_FLOW_AP_APP_ID
,      BUS_FLOW_INV_DIST_TYPE
,      BUS_FLOW_INV_ENTITY_CODE
,      BUS_FLOW_INV_DIST_ID
,      BUS_FLOW_INV_ID
,      BUS_FLOW_PO_APP_ID
,      BUS_FLOW_PO_DIST_TYPE
,      BUS_FLOW_PO_ENTITY_CODE
,      BUS_FLOW_PAYMENT_DIST_TYPE
,      BUS_FLOW_PAYMENT_ENTITY_CODE
,      BUS_FLOW_PAYMENT_DIST_ID
,      BUS_FLOW_PAYMENT_ID
,      AID_PROJECT_ID
,      AID_TASK_ID
,      AID_EXPENDITURE_TYPE
,      AID_EXPENDITURE_ORG_ID
,      BF_RETAINED_INV_ID_PMT
,      BF_RETAINED_INV_DIST_ID_PMT
,      BF_RETAINED_INV_ID_CLR
,      BF_RETAINED_INV_DIST_ID_CLR
,      AID_RET_RELATED_DIST_CCID
,      AID_AWT_RELATED_ID
,      APHD_QUANTITY_VARIANCE
,      APHD_INV_BASE_QTY_VARIANCE
,      APHD_AMOUNT_VARIANCE
,      APHD_INV_BASE_AMT_VARIANCE
,      AID_DETAIL_TAX_DIST_ID
,      AID_ENCUMBERED_FLAG
,      POD_PO_DISTRIBUTION_ID
,      POD_ENCUMBERED_FLAG
,      POD_ENCUMBERED_AMOUNT
,      POD_GL_ENCUMBERED_DATE
,      POD_GL_ENCUMBERED_PERIOD_NAME
,      POD_ATTRIBUTE_CATEGORY
,      POD_ATTRIBUTE1
,      POD_ATTRIBUTE2
,      POD_ATTRIBUTE3
,      POD_ATTRIBUTE4
,      POD_ATTRIBUTE5
,      POD_ATTRIBUTE6
,      POD_ATTRIBUTE7
,      POD_ATTRIBUTE8
,      POD_ATTRIBUTE9
,      POD_ATTRIBUTE10
,      POD_ATTRIBUTE11
,      POD_ATTRIBUTE12
,      POD_ATTRIBUTE13
,      POD_ATTRIBUTE14
,      POD_ATTRIBUTE15
,      POD_DISTRIBUTION_NUM
,      POD_ACCRUE_ON_RECEIPT_FLAG
,      POD_CCID
,      PO_VARIANCE_ACCOUNT
,      RELATED_INV_DIST_DEST_TYPE
,      POD_PO_HEADER_ID
,      POD_PO_LINE_ID
,      POD_LINE_LOCATION_ID
,      BUS_FLOW_PAYMENT_MAT_DIST_ID
,      OVERRIDE_ACCTD_AMT_FLAG
,      AI_PAYMENT_STATUS_FLAG
,      ENCUMBRANCE_AMOUNT
,      AWT_RELATED_DIST_TYPE
FROM APPS.AP_PAYMENT_EXTRACT_DETAILS_V;

Dependencies

[top of page]

APPS.AP_PAYMENT_EXTRACT_DETAILS_V references the following:

APPS: AP_AWT_GROUPS; AP_INVOICES_ALL; AP_INVOICE_DISTRIBUTIONS_ALL; AP_INVOICE_LINES_ALL; AP_INVOICE_PAYMENTS_ALL; AP_PAYMENT_HISTORY_ALL; AP_PAYMENT_HIST_DISTS; AP_SYSTEM_PARAMETERS_ALL; PO_DISTRIBUTIONS_ALL; XLA_EVENTS_GT; ZX_AP_DEF_TAX_EXTRACT_V

APPS.AP_PAYMENT_EXTRACT_DETAILS_V is referenced by following:

APPS: AP_PAYMENT_EXTRACT_DETAILS_VL; FV_SLA_PROCESSING_PKG - show dependent code; XLA_00200_AAD_S_000002_PKG - show dependent code; XLA_00200_AAD_S_000006_PKG - show dependent code; XLA_00200_AAD_S_000010_PKG - show dependent code; XLA_00200_AAD_S_000011_PKG - show dependent code; XLA_00200_AAD_S_000012_PKG - show dependent code; XLA_00200_AAD_S_000020_PKG - show dependent code