[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_PREPAYAPP_EXTRACT_DTLS_BC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  FND.AP_PREPAYAPP_EXTRACT_DTLS_BC_V
SQLAP.AP_PREPAYAPP_EXTRACT_DTLS_BC_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EVENT_ID | NUMBER | (15) | ||
| LINE_NUMBER | NUMBER | (15) | Yes | |
| DISTRIBUTION_LINK_TYPE | CHAR | (9) | ||
| DEFERRED_OPTION | VARCHAR2 | (1) | ||
| DEFERRED_START_DATE | DATE | |||
| DEFERRED_END_DATE | DATE | |||
| DEFERRED_NUMBER_OF_PERIODS | NUMBER | |||
| DEFERRED_PERIOD_TYPE | VARCHAR2 | (30) | ||
| APAD_DISTRIBUTION_IDENTIFIER | NUMBER | (15) | Yes | |
| DIST_ACCOUNT_REVERSAL_OPTION | VARCHAR2 | (1) | ||
| APAD_DIST_LOOKUP_CODE | VARCHAR2 | (30) | Yes | |
| APAD_INVOICE_ADJ_EVENT_ID | NUMBER | (15) | ||
| APPH_PREPAY_INVOICE_ID | NUMBER | (15) | Yes | |
| APAD_AMOUNT | NUMBER | |||
| PREPAY_PAY_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| PREPAY_CLEAR_CURRENCY_CODE | VARCHAR2 | (15) | ||
| AIL_LINE_NUMBER | NUMBER | Yes | ||
| AIL_LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | |
| AIL_ACCOUNT_SEGMENT | VARCHAR2 | (25) | ||
| AIL_BALANCING_SEGMENT | VARCHAR2 | (25) | ||
| AIL_COST_CENTER_SEGMENT | VARCHAR2 | (25) | ||
| AIL_OVERLAY_DIST_CODE_CONCAT | VARCHAR2 | (250) | ||
| AIL_DEFAULT_DIST_CCID | NUMBER | (15) | ||
| AIL_ACCOUNTING_DATE | DATE | Yes | ||
| AIL_PERIOD_NAME | VARCHAR2 | (15) | ||
| AIL_AMOUNT | NUMBER | Yes | ||
| AIL_ROUNDING_AMT | NUMBER | |||
| AIL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| AIL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| AIL_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| SUMMARY_TAX_LINE_ID | NUMBER | |||
| AID_ACCOUNTING_DATE | DATE | Yes | ||
| AID_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | Yes | |
| AID_LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | |
| AID_PERIOD_NAME | VARCHAR2 | (15) | Yes | |
| AID_ACCTS_PAY_CCID | NUMBER | (15) | ||
| AID_DIST_CCID | NUMBER | (15) | Yes | |
| AID_DESCRIPTION | VARCHAR2 | (240) | ||
| AID_EXCHANGE_RATE_VARIANCE | NUMBER | |||
| AID_INVOICE_PRICE_VARIANCE | NUMBER | |||
| AID_RATE_VAR_CCID | NUMBER | (15) | ||
| AID_REVERSAL_FLAG | VARCHAR2 | (1) | ||
| AID_AMOUNT_ENCUMBERED | NUMBER | |||
| AID_ENCUMBERED_FLAG | VARCHAR2 | (1) | ||
| AID_EXCHANGE_DATE | DATE | |||
| AID_EXCHANGE_RATE | NUMBER | |||
| AID_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
| AID_STAT_AMOUNT | NUMBER | |||
| AID_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| AID_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| AID_PARENT_INVOICE_ID | NUMBER | (15) | ||
| AID_GLOBAL_ATTRIBUTE_CAT | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE16 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE17 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE18 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE19 | VARCHAR2 | (150) | ||
| AID_GLOBAL_ATTRIBUTE20 | VARCHAR2 | (150) | ||
| AID_MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | (80) | ||
| AID_MERCHANT_NAME | VARCHAR2 | (80) | ||
| AID_PREPAY_DISTRIBUTION_ID | NUMBER | (15) | ||
| AID_INV_INCLUDES_PREPAY_FLAG | VARCHAR2 | (1) | ||
| AID_INVOICE_LINE_NUMBER | NUMBER | |||
| AID_ROUNDING_AMOUNT | NUMBER | |||
| AID_AMT_AT_PREPAY_PAY_XRATE | NUMBER | |||
| AID_PREPAY_TAX_PARENT_ID | NUMBER | (15) | ||
| REVERSED_PREPAY_APP_DIST_ID | NUMBER | (15) | ||
| INV_DIST_BASE_AMOUNT | NUMBER | |||
| INV_ENTERED_AMOUNT | NUMBER | |||
| AID_INVOICE_DIST_ID | NUMBER | (15) | Yes | |
| AID_DETAIL_TAX_DIST_ID | NUMBER | |||
| APAD_PREPAY_XDATE | DATE | |||
| APAD_PREPAY_PAY_XDATE | DATE | |||
| APAD_PREPAY_XRATE | NUMBER | |||
| APAD_PREPAY_PAY_XRATE | NUMBER | |||
| APAD_PREPAY_XRATE_TYPE | VARCHAR2 | (30) | ||
| APAD_PREPAY_PAY_XRATE_TYPE | VARCHAR2 | (30) | ||
| APAD_PREPAY_CLR_XRATE | NUMBER | |||
| APAD_PREPAY_CLR_XRATE_TYPE | VARCHAR2 | (30) | ||
| APAD_PREPAY_CLR_XDATE | DATE | |||
| BASE_AMT_AT_PP_CLR_XRATE | NUMBER | |||
| BASE_AMT_AT_PP_XRATE | NUMBER | |||
| BASE_AMT_AT_PP_PAY_XRATE | NUMBER | |||
| APAD_BASE_AMOUNT | NUMBER | |||
| APAD_ROUNDING_AMOUNT | NUMBER | |||
| APAD_BASE_AMT_NO_ROUND | NUMBER | |||
| APAD_BASE_AMOUNT_DIFF | NUMBER | |||
| INV_PREPMT_GAIN_LOSS_INDICATOR | VARCHAR2 | (4) | ||
| PO_DISTRIBUTION_ID | NUMBER | (15) | ||
| 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 | (15) | Yes | |
| BUS_FLOW_INV_ID | NUMBER | (15) | Yes | |
| BUS_FLOW_PO_APP_ID | NUMBER | |||
| BUS_FLOW_PO_DIST_TYPE | CHAR | (20) | ||
| BUS_FLOW_PO_ENTITY_CODE | VARCHAR2 | (14) | ||
| BUS_FLOW_PO_DOC_ID | NUMBER | |||
| BF_ACCRUAL_PREPAY_ENTITY_CODE | CHAR | (11) | ||
| BF_CASH_ALWAYS_PREPAY_ENTITY | CHAR | (11) | ||
| BF_CASHCLEARONLY_PREPAY_ENTITY | VARCHAR2 | (14) | ||
| BF_ACCRUAL_PREPAY_DIST_TYPE | CHAR | (11) | ||
| BF_CASH_ALWAYS_PP_DIST_TYPE | CHAR | (11) | ||
| BF_CASHCLEARONLY_PP_DIST_TYPE | CHAR | (7) | ||
| BF_PREPAY_REC_DIST_ID | NUMBER | (15) | Yes | |
| BF_PREPAY_REC_INV | NUMBER | (15) | Yes | |
| BF_ACCRUAL_PP_DIST_ID | NUMBER | (15) | ||
| BF_ACCRUAL_PP_INV | NUMBER | (15) | Yes | |
| BF_CASHALWAYS_PP_PMT_ID | NUMBER | |||
| BF_CASHALWAYS_PP_PMT_DIST_ID | NUMBER | |||
| BF_CASHCLEAR_PP_CLEAR_DIST_ID | NUMBER | |||
| AID_PROJECT_ID | NUMBER | (15) | ||
| AID_TASK_ID | NUMBER | (15) | ||
| AID_EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
| AID_EXPENDITURE_ORG_ID | NUMBER | (15) | ||
| AID_AWARD_ID | NUMBER | (15) | ||
| AID_AMOUNT | NUMBER | |||
| BF_RET_INV_ASSOC_TO_PP_RECIP | NUMBER | (15) | ||
| BF_RET_DIST_ASSOC_TO_PP_RECIP | NUMBER | (15) | ||
| AI_RECIPIENT_INV_TYPE | VARCHAR2 | (25) | ||
| RECP_INV_DIST_TYPE | VARCHAR2 | (25) | Yes | |
| APAD_PREPAY_APP_DIST_ID | NUMBER | (15) | Yes | |
| RECP_INV_DIST_CCID | NUMBER | (15) | Yes | |
| AID_RET_RELATED_DIST_CCID | NUMBER | (15) | ||
| VARIANCE_PARENT_DIST_ID | NUMBER | (15) | ||
| APAD_QUANTITY_VARIANCE | NUMBER | |||
| APAD_INV_BASE_QTY_VARIANCE | NUMBER | |||
| APAD_AMOUNT_VARIANCE | NUMBER | |||
| APAD_INV_BASE_AMT_VARIANCE | NUMBER | |||
| RECP_DETAIL_TAX_DIST_ID | NUMBER | |||
| 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 | |||
| UPG_AP_ENCUM_OPTION | VARCHAR2 | (4000) | ||
| UPG_CR_ENC_TYPE_ID | VARCHAR2 | (4) | ||
| UPG_ENC_CR_CCID | VARCHAR2 | (40) | ||
| UPG_ENC_CR_BASE_AMT | VARCHAR2 | (40) | ||
| UPG_ENC_CR_AMT | VARCHAR2 | (40) | ||
| 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 | CHAR | (15) | ||
| UPG_ENC_CR_ACCT_CLASS | CHAR | (3) | ||
| OVERRIDE_ACCTD_AMT_FLAG | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, DISTRIBUTION_LINK_TYPE
, DEFERRED_OPTION
, DEFERRED_START_DATE
, DEFERRED_END_DATE
, DEFERRED_NUMBER_OF_PERIODS
, DEFERRED_PERIOD_TYPE
, APAD_DISTRIBUTION_IDENTIFIER
, DIST_ACCOUNT_REVERSAL_OPTION
, APAD_DIST_LOOKUP_CODE
, APAD_INVOICE_ADJ_EVENT_ID
, APPH_PREPAY_INVOICE_ID
, APAD_AMOUNT
, PREPAY_PAY_CURRENCY_CODE
, PREPAY_CLEAR_CURRENCY_CODE
, AIL_LINE_NUMBER
, AIL_LINE_TYPE_LOOKUP_CODE
, AIL_ACCOUNT_SEGMENT
, AIL_BALANCING_SEGMENT
, AIL_COST_CENTER_SEGMENT
, AIL_OVERLAY_DIST_CODE_CONCAT
, AIL_DEFAULT_DIST_CCID
, AIL_ACCOUNTING_DATE
, AIL_PERIOD_NAME
, AIL_AMOUNT
, AIL_ROUNDING_AMT
, AIL_ATTRIBUTE_CATEGORY
, AIL_ATTRIBUTE1
, AIL_ATTRIBUTE2
, AIL_ATTRIBUTE3
, AIL_ATTRIBUTE4
, AIL_ATTRIBUTE5
, AIL_ATTRIBUTE6
, AIL_ATTRIBUTE7
, AIL_ATTRIBUTE8
, AIL_ATTRIBUTE9
, AIL_ATTRIBUTE10
, AIL_ATTRIBUTE11
, AIL_ATTRIBUTE12
, AIL_ATTRIBUTE13
, AIL_ATTRIBUTE14
, AIL_ATTRIBUTE15
, AIL_GLOBAL_ATTRIBUTE_CATEGORY
, AIL_GLOBAL_ATTRIBUTE1
, AIL_GLOBAL_ATTRIBUTE2
, AIL_GLOBAL_ATTRIBUTE3
, AIL_GLOBAL_ATTRIBUTE4
, AIL_GLOBAL_ATTRIBUTE5
, AIL_GLOBAL_ATTRIBUTE6
, AIL_GLOBAL_ATTRIBUTE7
, AIL_GLOBAL_ATTRIBUTE8
, AIL_GLOBAL_ATTRIBUTE9
, AIL_GLOBAL_ATTRIBUTE10
, AIL_GLOBAL_ATTRIBUTE11
, AIL_GLOBAL_ATTRIBUTE12
, AIL_GLOBAL_ATTRIBUTE13
, AIL_GLOBAL_ATTRIBUTE14
, AIL_GLOBAL_ATTRIBUTE15
, AIL_GLOBAL_ATTRIBUTE16
, AIL_GLOBAL_ATTRIBUTE17
, AIL_GLOBAL_ATTRIBUTE18
, AIL_GLOBAL_ATTRIBUTE19
, AIL_GLOBAL_ATTRIBUTE20
, SUMMARY_TAX_LINE_ID
, AID_ACCOUNTING_DATE
, AID_DISTRIBUTION_LINE_NUMBER
, AID_LINE_TYPE_LOOKUP_CODE
, AID_PERIOD_NAME
, AID_ACCTS_PAY_CCID
, AID_DIST_CCID
, AID_DESCRIPTION
, AID_EXCHANGE_RATE_VARIANCE
, AID_INVOICE_PRICE_VARIANCE
, AID_RATE_VAR_CCID
, AID_REVERSAL_FLAG
, AID_AMOUNT_ENCUMBERED
, AID_ENCUMBERED_FLAG
, AID_EXCHANGE_DATE
, AID_EXCHANGE_RATE
, AID_EXCHANGE_RATE_TYPE
, AID_STAT_AMOUNT
, AID_ATTRIBUTE1
, AID_ATTRIBUTE10
, AID_ATTRIBUTE11
, AID_ATTRIBUTE12
, AID_ATTRIBUTE13
, AID_ATTRIBUTE14
, AID_ATTRIBUTE15
, AID_ATTRIBUTE2
, AID_ATTRIBUTE3
, AID_ATTRIBUTE4
, AID_ATTRIBUTE5
, AID_ATTRIBUTE6
, AID_ATTRIBUTE7
, AID_ATTRIBUTE8
, AID_ATTRIBUTE9
, AID_ATTRIBUTE_CATEGORY
, AID_PARENT_INVOICE_ID
, AID_GLOBAL_ATTRIBUTE_CAT
, AID_GLOBAL_ATTRIBUTE1
, AID_GLOBAL_ATTRIBUTE2
, AID_GLOBAL_ATTRIBUTE3
, AID_GLOBAL_ATTRIBUTE4
, AID_GLOBAL_ATTRIBUTE5
, AID_GLOBAL_ATTRIBUTE6
, AID_GLOBAL_ATTRIBUTE7
, AID_GLOBAL_ATTRIBUTE8
, AID_GLOBAL_ATTRIBUTE9
, AID_GLOBAL_ATTRIBUTE10
, AID_GLOBAL_ATTRIBUTE11
, AID_GLOBAL_ATTRIBUTE12
, AID_GLOBAL_ATTRIBUTE13
, AID_GLOBAL_ATTRIBUTE14
, AID_GLOBAL_ATTRIBUTE15
, AID_GLOBAL_ATTRIBUTE16
, AID_GLOBAL_ATTRIBUTE17
, AID_GLOBAL_ATTRIBUTE18
, AID_GLOBAL_ATTRIBUTE19
, AID_GLOBAL_ATTRIBUTE20
, AID_MERCHANT_DOCUMENT_NUMBER
, AID_MERCHANT_NAME
, AID_PREPAY_DISTRIBUTION_ID
, AID_INV_INCLUDES_PREPAY_FLAG
, AID_INVOICE_LINE_NUMBER
, AID_ROUNDING_AMOUNT
, AID_AMT_AT_PREPAY_PAY_XRATE
, AID_PREPAY_TAX_PARENT_ID
, REVERSED_PREPAY_APP_DIST_ID
, INV_DIST_BASE_AMOUNT
, INV_ENTERED_AMOUNT
, AID_INVOICE_DIST_ID
, AID_DETAIL_TAX_DIST_ID
, APAD_PREPAY_XDATE
, APAD_PREPAY_PAY_XDATE
, APAD_PREPAY_XRATE
, APAD_PREPAY_PAY_XRATE
, APAD_PREPAY_XRATE_TYPE
, APAD_PREPAY_PAY_XRATE_TYPE
, APAD_PREPAY_CLR_XRATE
, APAD_PREPAY_CLR_XRATE_TYPE
, APAD_PREPAY_CLR_XDATE
, BASE_AMT_AT_PP_CLR_XRATE
, BASE_AMT_AT_PP_XRATE
, BASE_AMT_AT_PP_PAY_XRATE
, APAD_BASE_AMOUNT
, APAD_ROUNDING_AMOUNT
, APAD_BASE_AMT_NO_ROUND
, APAD_BASE_AMOUNT_DIFF
, INV_PREPMT_GAIN_LOSS_INDICATOR
, PO_DISTRIBUTION_ID
, 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_PO_DOC_ID
, BF_ACCRUAL_PREPAY_ENTITY_CODE
, BF_CASH_ALWAYS_PREPAY_ENTITY
, BF_CASHCLEARONLY_PREPAY_ENTITY
, BF_ACCRUAL_PREPAY_DIST_TYPE
, BF_CASH_ALWAYS_PP_DIST_TYPE
, BF_CASHCLEARONLY_PP_DIST_TYPE
, BF_PREPAY_REC_DIST_ID
, BF_PREPAY_REC_INV
, BF_ACCRUAL_PP_DIST_ID
, BF_ACCRUAL_PP_INV
, BF_CASHALWAYS_PP_PMT_ID
, BF_CASHALWAYS_PP_PMT_DIST_ID
, BF_CASHCLEAR_PP_CLEAR_DIST_ID
, AID_PROJECT_ID
, AID_TASK_ID
, AID_EXPENDITURE_TYPE
, AID_EXPENDITURE_ORG_ID
, AID_AWARD_ID
, AID_AMOUNT
, BF_RET_INV_ASSOC_TO_PP_RECIP
, BF_RET_DIST_ASSOC_TO_PP_RECIP
, AI_RECIPIENT_INV_TYPE
, RECP_INV_DIST_TYPE
, APAD_PREPAY_APP_DIST_ID
, RECP_INV_DIST_CCID
, AID_RET_RELATED_DIST_CCID
, VARIANCE_PARENT_DIST_ID
, APAD_QUANTITY_VARIANCE
, APAD_INV_BASE_QTY_VARIANCE
, APAD_AMOUNT_VARIANCE
, APAD_INV_BASE_AMT_VARIANCE
, RECP_DETAIL_TAX_DIST_ID
, 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
, 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
, OVERRIDE_ACCTD_AMT_FLAG
FROM APPS.AP_PREPAYAPP_EXTRACT_DTLS_BC_V;
APPS
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_LINES_ALL
AP_PAYMENT_HISTORY_ALL
AP_PAYMENT_HIST_DISTS
AP_PREPAY_APP_DISTS
AP_PREPAY_HISTORY_ALL
FINANCIALS_SYSTEM_PARAMS_ALL
GL_ENCUMBRANCE_TYPES
PO_DISTRIBUTIONS_ALL
PSA_BC_XLA_PUB
- show dependent code
APPS
XLA_00200_AAD_S_000006_BC_PKG
- show dependent code
XLA_00200_AAD_S_000010_BC_PKG
- show dependent code
|
|
|
|