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: ViewFND.AP_PAYMENT_EXTRACT_DETAILS_V
ViewSQLAP.AP_PAYMENT_EXTRACT_DETAILS_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
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 CHAR (4)
INV_CLR_GAIN_LOSS_INDICATOR CHAR (4)
PMT_MAT_GAIN_LOSS_INDICATOR CHAR (4)
MAT_CLR_GAIN_LOSS_INDICATOR CHAR (4)
PMT_CLR_GAIN_LOSS_INDICATOR CHAR (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)
AWT_RELATED_LINE_TYPE_LOOKUP VARCHAR2 (25)
ENCUMBRANCE_PMT_BASE_AMOUNT NUMBER

CASH_PMT_BASE_AMOUNT NUMBER

AWT_RELATED_ENC_FLAG VARCHAR2 (1)
AID_DESC_PAY VARCHAR2 (240)
UPG_AP_ENCUM_OPTION VARCHAR2 (4000)
UPG_CR_ENC_TYPE_ID NUMBER (15) Yes
UPG_ENC_CR_CCID NUMBER (15) Yes
UPG_ENC_CR_BASE_AMT NUMBER

UPG_ENC_CR_AMT NUMBER

UPG_DR_ENC_TYPE_ID NUMBER (15) Yes
UPG_ENC_DR_CCID NUMBER (15) Yes
UPG_ENC_DR_BASE_AMT NUMBER

UPG_ENC_DR_AMT NUMBER

UPG_ENC_DR_ACCT_CLASS VARCHAR2 (0)
UPG_ENC_CR_ACCT_CLASS VARCHAR2 (0)
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
,      AWT_RELATED_LINE_TYPE_LOOKUP
,      ENCUMBRANCE_PMT_BASE_AMOUNT
,      CASH_PMT_BASE_AMOUNT
,      AWT_RELATED_ENC_FLAG
,      AID_DESC_PAY
,      UPG_AP_ENCUM_OPTION
,      UPG_CR_ENC_TYPE_ID
,      UPG_ENC_CR_CCID
,      UPG_ENC_CR_BASE_AMT
,      UPG_ENC_CR_AMT
,      UPG_DR_ENC_TYPE_ID
,      UPG_ENC_DR_CCID
,      UPG_ENC_DR_BASE_AMT
,      UPG_ENC_DR_AMT
,      UPG_ENC_DR_ACCT_CLASS
,      UPG_ENC_CR_ACCT_CLASS
FROM APPS.AP_PAYMENT_EXTRACT_DETAILS_V;

Dependencies

[top of page]

APPS.AP_PAYMENT_EXTRACT_DETAILS_V references the following:

SchemaAPPS
SynonymAP_AWT_GROUPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
SynonymAP_INVOICE_LINES_ALL
SynonymAP_INVOICE_PAYMENTS_ALL
SynonymAP_PAYMENT_HISTORY_ALL
SynonymAP_PAYMENT_HIST_DISTS
SynonymAP_SYSTEM_PARAMETERS_ALL
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymGL_ENCUMBRANCE_TYPES
SynonymPO_DISTRIBUTIONS_ALL
PL/SQL PackagePSA_BC_XLA_PUB - show dependent code
SynonymXLA_EVENTS_GT
ViewZX_AP_DEF_TAX_EXTRACT_V
APPS.AP_PAYMENT_EXTRACT_DETAILS_V is referenced by following:

SchemaAPPS
ViewAP_PAYMENT_EXTRACT_DETAILS_VL
Package BodyXLA_00200_AAD_S_000002_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000006_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000010_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000011_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000012_PKG - show dependent code
Package BodyXLA_00200_AAD_S_000020_PKG - show dependent code