[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AP_INVOICE_EXTRACT_HEADER_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  SQLAP.AP_INVOICE_EXTRACT_HEADER_V
|
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EVENT_ID | NUMBER | (15) | ||
| AI_SOURCE | VARCHAR2 | (25) | ||
| INV_TRANSACTION_NUMBER | VARCHAR2 | (50) | Yes | |
| INV_DOC_SEQUENCE_IDENTIFIER | NUMBER | |||
| INV_DOC_SEQUENCE_VALUE | NUMBER | |||
| INV_DOC_SEQUENCE_CATEGORY | VARCHAR2 | (30) | ||
| DOC_SEQUENCE_NAME | VARCHAR2 | (30) | ||
| INV_PARTY_TYPE | VARCHAR2 | (1) | ||
| THIRD_PARTY_TYPE | VARCHAR2 | (1) | ||
| AB_BATCH_NAME | VARCHAR2 | (50) | ||
| AI_ACCTS_PAY_CCID | NUMBER | (15) | ||
| AI_INVOICE_ID | NUMBER | (15) | Yes | |
| AI_ORG_ID | NUMBER | (15) | ||
| AI_INVOICE_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| AI_VENDOR_ID | NUMBER | |||
| AI_VENDOR_SITE_ID | NUMBER | |||
| AI_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| AI_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| AI_CANCELLED_DATE | DATE | |||
| AI_DESCRIPTION | VARCHAR2 | (240) | ||
| AI_INVOICE_AMOUNT | NUMBER | |||
| AI_INVOICE_BASE_AMOUNT | NUMBER | |||
| AI_INVOICE_DATE | DATE | |||
| AI_INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
| AI_VAT_CODE | VARCHAR2 | (15) | ||
| AI_VOUCHER_NUM | VARCHAR2 | (50) | ||
| INV_AMOUNT_PAID | NUMBER | |||
| INV_DISCOUNT_AMOUNT_TAKEN | NUMBER | |||
| INV_DISTRIBUTION_TOTAL | NUMBER | |||
| INV_AWT_GROUP_ID | NUMBER | (15) | ||
| INV_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_16 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_17 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_18 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_19 | VARCHAR2 | (150) | ||
| INV_GLOBAL_ATTRIBUTE_20 | VARCHAR2 | (150) | ||
| INV_GL_DATE | DATE | Yes | ||
| INV_HISTORICAL_FLAG | VARCHAR2 | (1) | ||
| TRANSAC_REVERSAL_FLAG | VARCHAR2 | (1) | ||
| LEDGER_ID | NUMBER | (15) | Yes | |
| INV_EXCHANGE_DATE | DATE | |||
| INV_EXCHANGE_RATE | NUMBER | |||
| INV_EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | ||
| AI_PARTY_ID | NUMBER | (15) | ||
| AI_PARTY_SITE_ID | NUMBER | (15) | ||
| POV_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| POV_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| POV_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| POV_VENDOR_NAME_ALT | VARCHAR2 | (320) | ||
| POV_VENDOR_ID | NUMBER | |||
| POV_SEGMENT1 | VARCHAR2 | (30) | ||
| POV_VENDOR_NAME | VARCHAR2 | (360) | ||
| POV_SEGMENT2 | VARCHAR2 | (30) | ||
| POV_SEGMENT3 | VARCHAR2 | (30) | ||
| POV_SEGMENT4 | VARCHAR2 | (30) | ||
| POV_SEGMENT5 | VARCHAR2 | (30) | ||
| POV_MERCHANT_TYPE_LOOKUP_CODE | VARCHAR2 | (30) | ||
| POV_GLOBAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_16 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_17 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_18 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_19 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_20 | VARCHAR2 | (150) | ||
| POV_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| POV_NUM_1099 | VARCHAR2 | (30) | ||
| PARTY_ID | NUMBER | |||
| POS_ATTRIBUTE1 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE10 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE11 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE12 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE13 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE14 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE15 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE2 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE3 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE4 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE5 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE6 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE7 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE8 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE9 | VARCHAR2 | (150) | ||
| POS_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| POS_ADDRESS_LINE1 | VARCHAR2 | (240) | ||
| POS_ADDRESS_LINE2 | VARCHAR2 | (240) | ||
| POS_ADDRESS_LINE3 | VARCHAR2 | (240) | ||
| POS_ADDRESS_LINE4 | VARCHAR2 | (240) | ||
| POS_ADDRESS_LINES_ALT | VARCHAR2 | (560) | ||
| POS_CITY | VARCHAR2 | (60) | ||
| POS_COUNTY | VARCHAR2 | (150) | ||
| POS_COUNTRY | VARCHAR2 | (60) | ||
| POS_VENDOR_SITE_CODE | VARCHAR2 | (15) | ||
| POS_ZIP | VARCHAR2 | (60) | ||
| POS_PROVINCE | VARCHAR2 | (150) | ||
| POS_STATE | VARCHAR2 | (150) | ||
| POS_VENDOR_SITE_ID | NUMBER | |||
| POS_GLOBAL_ATTRIBUTE_1 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_2 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_3 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_4 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_5 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_6 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_7 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_8 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_9 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_10 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_11 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_12 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_13 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_14 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_15 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_16 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_17 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_18 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_19 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_20 | VARCHAR2 | (150) | ||
| POS_GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| POS_FDP_CCID | NUMBER | |||
| POS_PARTY_SITE_ID | NUMBER | |||
| POS_ORG_ID | NUMBER | |||
| POS_VENDOR_ID | NUMBER | |||
| AI_PAYMENT_STATUS_FLAG | VARCHAR2 | (1) | ||
| AI_PAYMENT_METHOD_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, AI_SOURCE
, INV_TRANSACTION_NUMBER
, INV_DOC_SEQUENCE_IDENTIFIER
, INV_DOC_SEQUENCE_VALUE
, INV_DOC_SEQUENCE_CATEGORY
, DOC_SEQUENCE_NAME
, INV_PARTY_TYPE
, THIRD_PARTY_TYPE
, AB_BATCH_NAME
, AI_ACCTS_PAY_CCID
, AI_INVOICE_ID
, AI_ORG_ID
, AI_INVOICE_CURRENCY_CODE
, AI_VENDOR_ID
, AI_VENDOR_SITE_ID
, AI_ATTRIBUTE_CATEGORY
, AI_ATTRIBUTE1
, AI_ATTRIBUTE10
, AI_ATTRIBUTE11
, AI_ATTRIBUTE12
, AI_ATTRIBUTE13
, AI_ATTRIBUTE14
, AI_ATTRIBUTE15
, AI_ATTRIBUTE2
, AI_ATTRIBUTE3
, AI_ATTRIBUTE4
, AI_ATTRIBUTE5
, AI_ATTRIBUTE6
, AI_ATTRIBUTE7
, AI_ATTRIBUTE8
, AI_ATTRIBUTE9
, AI_CANCELLED_DATE
, AI_DESCRIPTION
, AI_INVOICE_AMOUNT
, AI_INVOICE_BASE_AMOUNT
, AI_INVOICE_DATE
, AI_INVOICE_TYPE_LOOKUP_CODE
, AI_VAT_CODE
, AI_VOUCHER_NUM
, INV_AMOUNT_PAID
, INV_DISCOUNT_AMOUNT_TAKEN
, INV_DISTRIBUTION_TOTAL
, INV_AWT_GROUP_ID
, INV_GLOBAL_ATTRIBUTE_CATEGORY
, INV_GLOBAL_ATTRIBUTE_1
, INV_GLOBAL_ATTRIBUTE_2
, INV_GLOBAL_ATTRIBUTE_3
, INV_GLOBAL_ATTRIBUTE_4
, INV_GLOBAL_ATTRIBUTE_5
, INV_GLOBAL_ATTRIBUTE_6
, INV_GLOBAL_ATTRIBUTE_7
, INV_GLOBAL_ATTRIBUTE_8
, INV_GLOBAL_ATTRIBUTE_9
, INV_GLOBAL_ATTRIBUTE_10
, INV_GLOBAL_ATTRIBUTE_11
, INV_GLOBAL_ATTRIBUTE_12
, INV_GLOBAL_ATTRIBUTE_13
, INV_GLOBAL_ATTRIBUTE_14
, INV_GLOBAL_ATTRIBUTE_15
, INV_GLOBAL_ATTRIBUTE_16
, INV_GLOBAL_ATTRIBUTE_17
, INV_GLOBAL_ATTRIBUTE_18
, INV_GLOBAL_ATTRIBUTE_19
, INV_GLOBAL_ATTRIBUTE_20
, INV_GL_DATE
, INV_HISTORICAL_FLAG
, TRANSAC_REVERSAL_FLAG
, LEDGER_ID
, INV_EXCHANGE_DATE
, INV_EXCHANGE_RATE
, INV_EXCHANGE_RATE_TYPE
, AI_PARTY_ID
, AI_PARTY_SITE_ID
, POV_ATTRIBUTE_CATEGORY
, POV_ATTRIBUTE1
, POV_ATTRIBUTE10
, POV_ATTRIBUTE11
, POV_ATTRIBUTE12
, POV_ATTRIBUTE13
, POV_ATTRIBUTE14
, POV_ATTRIBUTE15
, POV_ATTRIBUTE2
, POV_ATTRIBUTE3
, POV_ATTRIBUTE4
, POV_ATTRIBUTE5
, POV_ATTRIBUTE6
, POV_ATTRIBUTE7
, POV_ATTRIBUTE8
, POV_ATTRIBUTE9
, POV_VENDOR_NAME_ALT
, POV_VENDOR_ID
, POV_SEGMENT1
, POV_VENDOR_NAME
, POV_SEGMENT2
, POV_SEGMENT3
, POV_SEGMENT4
, POV_SEGMENT5
, POV_MERCHANT_TYPE_LOOKUP_CODE
, POV_GLOBAL_ATTRIBUTE_1
, POV_GLOBAL_ATTRIBUTE_2
, POV_GLOBAL_ATTRIBUTE_3
, POV_GLOBAL_ATTRIBUTE_4
, POV_GLOBAL_ATTRIBUTE_5
, POV_GLOBAL_ATTRIBUTE_6
, POV_GLOBAL_ATTRIBUTE_7
, POV_GLOBAL_ATTRIBUTE_8
, POV_GLOBAL_ATTRIBUTE_9
, POV_GLOBAL_ATTRIBUTE_10
, POV_GLOBAL_ATTRIBUTE_11
, POV_GLOBAL_ATTRIBUTE_12
, POV_GLOBAL_ATTRIBUTE_13
, POV_GLOBAL_ATTRIBUTE_14
, POV_GLOBAL_ATTRIBUTE_15
, POV_GLOBAL_ATTRIBUTE_16
, POV_GLOBAL_ATTRIBUTE_17
, POV_GLOBAL_ATTRIBUTE_18
, POV_GLOBAL_ATTRIBUTE_19
, POV_GLOBAL_ATTRIBUTE_20
, POV_GLOBAL_ATTRIBUTE_CATEGORY
, POV_NUM_1099
, PARTY_ID
, POS_ATTRIBUTE1
, POS_ATTRIBUTE10
, POS_ATTRIBUTE11
, POS_ATTRIBUTE12
, POS_ATTRIBUTE13
, POS_ATTRIBUTE14
, POS_ATTRIBUTE15
, POS_ATTRIBUTE2
, POS_ATTRIBUTE3
, POS_ATTRIBUTE4
, POS_ATTRIBUTE5
, POS_ATTRIBUTE6
, POS_ATTRIBUTE7
, POS_ATTRIBUTE8
, POS_ATTRIBUTE9
, POS_ATTRIBUTE_CATEGORY
, POS_ADDRESS_LINE1
, POS_ADDRESS_LINE2
, POS_ADDRESS_LINE3
, POS_ADDRESS_LINE4
, POS_ADDRESS_LINES_ALT
, POS_CITY
, POS_COUNTY
, POS_COUNTRY
, POS_VENDOR_SITE_CODE
, POS_ZIP
, POS_PROVINCE
, POS_STATE
, POS_VENDOR_SITE_ID
, POS_GLOBAL_ATTRIBUTE_1
, POS_GLOBAL_ATTRIBUTE_2
, POS_GLOBAL_ATTRIBUTE_3
, POS_GLOBAL_ATTRIBUTE_4
, POS_GLOBAL_ATTRIBUTE_5
, POS_GLOBAL_ATTRIBUTE_6
, POS_GLOBAL_ATTRIBUTE_7
, POS_GLOBAL_ATTRIBUTE_8
, POS_GLOBAL_ATTRIBUTE_9
, POS_GLOBAL_ATTRIBUTE_10
, POS_GLOBAL_ATTRIBUTE_11
, POS_GLOBAL_ATTRIBUTE_12
, POS_GLOBAL_ATTRIBUTE_13
, POS_GLOBAL_ATTRIBUTE_14
, POS_GLOBAL_ATTRIBUTE_15
, POS_GLOBAL_ATTRIBUTE_16
, POS_GLOBAL_ATTRIBUTE_17
, POS_GLOBAL_ATTRIBUTE_18
, POS_GLOBAL_ATTRIBUTE_19
, POS_GLOBAL_ATTRIBUTE_20
, POS_GLOBAL_ATTRIBUTE_CATEGORY
, POS_FDP_CCID
, POS_PARTY_SITE_ID
, POS_ORG_ID
, POS_VENDOR_ID
, AI_PAYMENT_STATUS_FLAG
, AI_PAYMENT_METHOD_CODE
FROM APPS.AP_INVOICE_EXTRACT_HEADER_V;
APPS
AP_BATCHES_ALL
AP_INVOICES_ALL
AP_SUPPLIERS
AP_SUPPLIER_SITES_ALL
FND_DOCUMENT_SEQUENCES
HZ_LOCATIONS
HZ_PARTIES
HZ_PARTY_SITES
XLA_EVENTS_GT
APPS
XLA_00200_AAD_S_000002_PKG
- show dependent code
XLA_00200_AAD_S_000006_BC_PKG
- show dependent code
XLA_00200_AAD_S_000006_PKG
- show dependent code
XLA_00200_AAD_S_000010_BC_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_BC_PKG
- show dependent code
XLA_00200_AAD_S_000012_PKG
- show dependent code
XLA_00200_AAD_S_000020_PKG
- show dependent code
|
|
|
|