[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_EXTRACT_INVOICE_DTLS_BC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  SQLAP.AP_EXTRACT_INVOICE_DTLS_BC_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EVENT_ID | NUMBER | |||
| LINE_NUMBER | NUMBER | (15) | ||
| DEFERRED_OPTION | VARCHAR2 | (1) | ||
| DEFERRED_START_DATE | DATE | |||
| DEFERRED_END_DATE | DATE | |||
| DEFERRED_PERIOD_TYPE | VARCHAR2 | (30) | ||
| DEFERRED_NUMBER_OF_PERIODS | NUMBER | |||
| INV_DISTRIBUTION_IDENTIFIER | NUMBER | (15) | ||
| DIST_ACCOUNT_REVERSAL_OPTION | CHAR | (1) | ||
| AID_ACCOUNTING_DATE | DATE | |||
| AID_AMOUNT | NUMBER | |||
| AID_ASSETS_TRACKING_FLAG | VARCHAR2 | (1) | ||
| AID_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| 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_AWARD_ID | NUMBER | (15) | ||
| AID_DESCRIPTION | VARCHAR2 | (240) | ||
| AID_DIST_CCID | NUMBER | (15) | ||
| AID_DISTRIBUTION_LINE_NUMBER | NUMBER | (15) | ||
| AID_EXPENDITURE_ITEM_DATE | DATE | |||
| AID_EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
| AID_INCOME_TAX_REGION | VARCHAR2 | (10) | ||
| AID_MERCHANT_DOCUMENT_NUMBER | VARCHAR2 | (80) | ||
| AID_MERCHANT_REFERENCE | VARCHAR2 | (240) | ||
| AID_MERCHANT_TAX_REG_NUMBER | VARCHAR2 | (80) | ||
| AID_MERCHANT_TAXPAYER_ID | VARCHAR2 | (80) | ||
| AID_PERIOD_NAME | VARCHAR2 | (15) | ||
| AID_REFERENCE_1 | VARCHAR2 | (30) | ||
| AID_REFERENCE_2 | VARCHAR2 | (30) | ||
| AID_STAT_AMOUNT | NUMBER | |||
| AID_TAX_RECOVERABLE_FLAG | VARCHAR2 | (1) | ||
| AID_TYPE_1099 | VARCHAR2 | (10) | ||
| AP_AWT_GROUP_NAME | VARCHAR2 | (25) | ||
| AIL_LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
| AIL_DESCRIPTION | VARCHAR2 | (240) | ||
| AIL_LINE_SOURCE | VARCHAR2 | (30) | ||
| AIL_LINE_GROUP_NUMBER | NUMBER | |||
| AIL_ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
| 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_ASSET_BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
| AIL_EXPENSE_GROUP | VARCHAR2 | (80) | ||
| AIL_MERCHANT_NAME | VARCHAR2 | (240) | ||
| 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_ASSETS_ADDITION_FLAG | VARCHAR2 | (1) | ||
| AID_LINE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
| AID_RATE_VAR_CCID | NUMBER | |||
| AID_REVERSAL_FLAG | VARCHAR2 | (1) | ||
| 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_CANCELLATION_FLAG | VARCHAR2 | (1) | ||
| AID_INVOICE_LINE_NUMBER | NUMBER | |||
| AID_INVOICE_DIST_ID | NUMBER | (15) | ||
| AID_PARENT_REVERSAL_ID | NUMBER | (15) | ||
| AID_AWT_FLAG | VARCHAR2 | (1) | ||
| ASAT_LIAB_CCID | NUMBER | |||
| ZRND_TAX_DIST_ID | NUMBER | |||
| SELF_ASSESSED_TAX_FLAG | VARCHAR2 | (1) | ||
| SELF_ASSESSED_TAX_ACCOUNT | NUMBER | |||
| AWT_RELATED_DIST_ACCOUNT | NUMBER | |||
| AIL_BASE_AMOUNT | NUMBER | |||
| AIL_AMOUNT | NUMBER | |||
| AID_ROUNDING_AMOUNT | NUMBER | |||
| INV_DIST_BASE_AMOUNT | NUMBER | |||
| AID_BASE_AMT_NO_ROUND | NUMBER | |||
| DISTRIBUTION_LINK_TYPE | CHAR | (11) | ||
| 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) | ||
| BUS_FLOW_INV_ID | NUMBER | (15) | ||
| BUS_FLOW_PO_APP_ID | NUMBER | |||
| BUS_FLOW_PO_DIST_TYPE | VARCHAR2 | (20) | ||
| BUS_FLOW_PO_ENTITY_CODE | VARCHAR2 | (14) | ||
| BUS_FLOW_PO_DIST_ID | NUMBER | |||
| BUS_FLOW_PO_DOC_ID | NUMBER | |||
| AID_PROJECT_ID | NUMBER | (15) | ||
| AID_TASK_ID | NUMBER | (15) | ||
| AID_EXPENDITURE_ORG_ID | NUMBER | (15) | ||
| AID_QUANTITY_VARIANCE | NUMBER | |||
| AID_BASE_QUANTITY_VARIANCE | NUMBER | |||
| AID_AMOUNT_VARIANCE | NUMBER | |||
| AID_BASE_AMOUNT_VARIANCE | NUMBER | |||
| AID_RET_RELATED_DIST_CCID | NUMBER | |||
| BUS_FLOW_RET_INV_ID | NUMBER | |||
| BUS_FLOW_RET_INV_DIST_ID | NUMBER | |||
| AID_FINAL_RELEASE_ROUNDING | NUMBER | |||
| AIL_UNIT_PRICE | NUMBER | |||
| AIL_QUANTITY_INVOICED | NUMBER | |||
| AID_UNIT_PRICE | NUMBER | |||
| AID_QUANTITY_INVOICED | NUMBER | |||
| AID_PARENT_INVOICE_ID | NUMBER | (15) | ||
| AID_FINAL_MATCH_FLAG | VARCHAR2 | (1) | ||
| AID_EXTRA_PO_ERV | NUMBER | |||
| ENCUMBRANCE_BASE_AMOUNT | NUMBER | |||
| ENCUMBRANCE_AMOUNT | NUMBER | |||
| VARIANCE_PARENT_DIST_ID | NUMBER | (15) | ||
| CHARGE_APPLICABLE_TO_DIST_ID | NUMBER | (15) | ||
| ALLOC_TO_MAIN_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 | |||
| UPG_AP_ENCUM_OPTION | VARCHAR2 | (4000) | ||
| UPG_CR_ENC_TYPE_ID | VARCHAR2 | (40) | ||
| UPG_ENC_CR_CCID | VARCHAR2 | (40) | ||
| UPG_ENC_CR_BASE_AMT | NUMBER | |||
| UPG_ENC_CR_AMT | VARCHAR2 | (40) | ||
| UPG_DR_ENC_TYPE_ID | NUMBER | |||
| UPG_ENC_DR_CCID | NUMBER | |||
| UPG_ENC_DR_BASE_AMT | NUMBER | |||
| UPG_ENC_DR_AMT | NUMBER | |||
| OVERRIDE_ACCTD_AMT_FLAG | VARCHAR2 | (1) | ||
| PO_RCV_INV_CURR_CONV_RATE | NUMBER | |||
| PO_RCV_INV_CURR_CONV_DATE | DATE | |||
| PO_RCV_INV_CURR_CONV_TYPE | VARCHAR2 | (30) | ||
| VARIANCE_PARENT_DIST_CCID | NUMBER | (15) | ||
| LCM_ENABLED | VARCHAR2 | (3) | ||
| ORGANIZATION_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, LINE_NUMBER
, DEFERRED_OPTION
, DEFERRED_START_DATE
, DEFERRED_END_DATE
, DEFERRED_PERIOD_TYPE
, DEFERRED_NUMBER_OF_PERIODS
, INV_DISTRIBUTION_IDENTIFIER
, DIST_ACCOUNT_REVERSAL_OPTION
, AID_ACCOUNTING_DATE
, AID_AMOUNT
, AID_ASSETS_TRACKING_FLAG
, AID_ATTRIBUTE_CATEGORY
, 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_AWARD_ID
, AID_DESCRIPTION
, AID_DIST_CCID
, AID_DISTRIBUTION_LINE_NUMBER
, AID_EXPENDITURE_ITEM_DATE
, AID_EXPENDITURE_TYPE
, AID_INCOME_TAX_REGION
, AID_MERCHANT_DOCUMENT_NUMBER
, AID_MERCHANT_REFERENCE
, AID_MERCHANT_TAX_REG_NUMBER
, AID_MERCHANT_TAXPAYER_ID
, AID_PERIOD_NAME
, AID_REFERENCE_1
, AID_REFERENCE_2
, AID_STAT_AMOUNT
, AID_TAX_RECOVERABLE_FLAG
, AID_TYPE_1099
, AP_AWT_GROUP_NAME
, AIL_LINE_TYPE_LOOKUP_CODE
, AIL_DESCRIPTION
, AIL_LINE_SOURCE
, AIL_LINE_GROUP_NUMBER
, AIL_ITEM_DESCRIPTION
, AIL_ACCOUNT_SEGMENT
, AIL_BALANCING_SEGMENT
, AIL_COST_CENTER_SEGMENT
, AIL_OVERLAY_DIST_CODE_CONCAT
, AIL_DEFAULT_DIST_CCID
, AIL_ASSET_BOOK_TYPE_CODE
, AIL_EXPENSE_GROUP
, AIL_MERCHANT_NAME
, 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_ASSETS_ADDITION_FLAG
, AID_LINE_TYPE_LOOKUP_CODE
, AID_RATE_VAR_CCID
, AID_REVERSAL_FLAG
, 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_CANCELLATION_FLAG
, AID_INVOICE_LINE_NUMBER
, AID_INVOICE_DIST_ID
, AID_PARENT_REVERSAL_ID
, AID_AWT_FLAG
, ASAT_LIAB_CCID
, ZRND_TAX_DIST_ID
, SELF_ASSESSED_TAX_FLAG
, SELF_ASSESSED_TAX_ACCOUNT
, AWT_RELATED_DIST_ACCOUNT
, AIL_BASE_AMOUNT
, AIL_AMOUNT
, AID_ROUNDING_AMOUNT
, INV_DIST_BASE_AMOUNT
, AID_BASE_AMT_NO_ROUND
, DISTRIBUTION_LINK_TYPE
, 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_DIST_ID
, BUS_FLOW_PO_DOC_ID
, AID_PROJECT_ID
, AID_TASK_ID
, AID_EXPENDITURE_ORG_ID
, AID_QUANTITY_VARIANCE
, AID_BASE_QUANTITY_VARIANCE
, AID_AMOUNT_VARIANCE
, AID_BASE_AMOUNT_VARIANCE
, AID_RET_RELATED_DIST_CCID
, BUS_FLOW_RET_INV_ID
, BUS_FLOW_RET_INV_DIST_ID
, AID_FINAL_RELEASE_ROUNDING
, AIL_UNIT_PRICE
, AIL_QUANTITY_INVOICED
, AID_UNIT_PRICE
, AID_QUANTITY_INVOICED
, AID_PARENT_INVOICE_ID
, AID_FINAL_MATCH_FLAG
, AID_EXTRA_PO_ERV
, ENCUMBRANCE_BASE_AMOUNT
, ENCUMBRANCE_AMOUNT
, VARIANCE_PARENT_DIST_ID
, CHARGE_APPLICABLE_TO_DIST_ID
, ALLOC_TO_MAIN_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
, 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
, OVERRIDE_ACCTD_AMT_FLAG
, PO_RCV_INV_CURR_CONV_RATE
, PO_RCV_INV_CURR_CONV_DATE
, PO_RCV_INV_CURR_CONV_TYPE
, VARIANCE_PARENT_DIST_CCID
, LCM_ENABLED
, ORGANIZATION_ID
FROM APPS.AP_EXTRACT_INVOICE_DTLS_BC_V;
APPS
AP_AWT_GROUPS
AP_INVOICES_ALL
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_LINES_ALL
AP_SELF_ASSESSED_TAX_DIST_ALL
AP_SYSTEM_PARAMETERS_ALL
AP_UTILITIES_PKG
- show dependent code
FINANCIALS_SYSTEM_PARAMS_ALL
GL_ENCUMBRANCE_TYPES
IGC_CC_SLA_BFLOW_PRIOR_V
PO_DISTRIBUTIONS_ALL
PO_HEADERS_ALL
PSA_BC_XLA_PUB
- show dependent code
RCV_TRANSACTIONS
APPS
XLA_00200_AAD_S_000006_BC_PKG
- show dependent code
XLA_00200_AAD_S_000010_BC_PKG
- show dependent code
XLA_00200_AAD_S_000012_BC_PKG
- show dependent code
|
|
|
|