[Home] [Help]
[Dependency Information]
| Object Name: | AP_INVOICE_EXTRACT_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | SQLAP.AP_INVOICE_EXTRACT_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
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
, AIL_REFERENCE_KEY1
, AIL_PRODUCT_TABLE
, OVERRIDE_ACCTD_AMT_FLAG
FROM APPS.AP_INVOICE_EXTRACT_DETAILS_V;
APPS
AP_AWT_GROUPS
AP_INVOICE_DISTRIBUTIONS_ALL
AP_INVOICE_LINES_ALL
AP_SELF_ASSESSED_TAX_DIST_ALL
FINANCIALS_SYSTEM_PARAMS_ALL
GL_ENCUMBRANCE_TYPES
PO_DISTRIBUTIONS_ALL
PSA_BC_XLA_PUB
- show dependent code
APPS
AP_INVOICE_EXTRACT_DETAILS_VL
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_000012_PKG
- show dependent code
XLA_00200_AAD_S_000020_PKG
- show dependent code
|
|
|
|