[Home] [Help] [Dependency Information]
Object Name: | DPP_XLA_CLAIM_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_ID | NUMBER | (15) | Event Id | |
PP_TRANSACTION_TYPE | VARCHAR2 | (30) | Yes | Type of transaction for which event needs to be processed. Possible values are:COST_UPDATE,SUPP_DSTR_CL,SUPP_CUST_CL,CUST_CL. |
DISTRIBUTION_TYPE | CHAR | (19) | Distribution Type : Possible values PP_COST_UPDATE, PP_CLAIM_SETTLEMENT | |
TRANSACTION_HEADER_ID | NUMBER | Yes | Unique identifier for the PP Transaction | |
BASE_TRANSACTION_HEADER_ID | NUMBER | Yes | This will store the trade management claim header ID (for claim settlement) | |
PP_TXN_NUMBER | VARCHAR2 | (40) | Yes | Pp Txn Number |
VENDOR_NAME | VARCHAR2 | (240) | Vendor Name | |
VENDOR_SITE_CODE | VARCHAR2 | (15) | Yes | Vendor Site Code |
TRANSFER_TO_GL_INDICATOR | CHAR | (1) | Transfer To Gl Indicator : Y | |
PP_ACCRUAL_CCID | NUMBER | Pp Accrual Ccid | ||
PP_COST_ADJ_CCID | NUMBER | Pp Cost Adj Ccid | ||
PP_CONTRA_LIAB_CCID | NUMBER | Pp Contra Liab Ccid | ||
PP_AP_CLEARING_CCID | NUMBER | Pp Ap Clearing Ccid | ||
PP_AR_CLEARING_CCID | NUMBER | Pp Ar Clearing Ccid | ||
CLAIM_ORG_ID | NUMBER | Claim Org Id | ||
PARTY_ID | NUMBER | Party Id | ||
PARTY_SITE_ID | NUMBER | Party Site Id | ||
PARTY_TYPE | VARCHAR2 | (1) | Party Type | |
HDR_ATTR_CATEGORY | VARCHAR2 | (30) | Descriptive flexfiled structure defining column | |
HDR_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HDR_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CONTACT_EMAIL_ADDRESS | VARCHAR2 | (2000) | Supplier contact persons email. | |
CONTACT_PHONE | VARCHAR2 | (40) | Supplier contact persons phone. | |
TRANSACTION_SOURCE | VARCHAR2 | (40) | Yes | Transaction Source: WebADI, XML, Script |
EFFECTIVE_START_DATE | DATE | Yes | The date from which the PP Transaction will be valid | |
DAYS_COVERED | NUMBER | Number of days covered as per the PP Transaction | ||
TRX_CURRENCY | VARCHAR2 | (15) | Yes | Transactional currency |
TRANSACTION_STATUS | VARCHAR2 | (20) | Yes | New, Pending Approval, Active, Rejected, Cancelled, Closed |
ORG_ID | NUMBER | Operating Unit |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_ID
, PP_TRANSACTION_TYPE
, DISTRIBUTION_TYPE
, TRANSACTION_HEADER_ID
, BASE_TRANSACTION_HEADER_ID
, PP_TXN_NUMBER
, VENDOR_NAME
, VENDOR_SITE_CODE
, TRANSFER_TO_GL_INDICATOR
, PP_ACCRUAL_CCID
, PP_COST_ADJ_CCID
, PP_CONTRA_LIAB_CCID
, PP_AP_CLEARING_CCID
, PP_AR_CLEARING_CCID
, CLAIM_ORG_ID
, PARTY_ID
, PARTY_SITE_ID
, PARTY_TYPE
, HDR_ATTR_CATEGORY
, HDR_ATTRIBUTE1
, HDR_ATTRIBUTE2
, HDR_ATTRIBUTE3
, HDR_ATTRIBUTE4
, HDR_ATTRIBUTE5
, HDR_ATTRIBUTE6
, HDR_ATTRIBUTE7
, HDR_ATTRIBUTE8
, HDR_ATTRIBUTE9
, HDR_ATTRIBUTE10
, HDR_ATTRIBUTE11
, HDR_ATTRIBUTE12
, HDR_ATTRIBUTE13
, HDR_ATTRIBUTE14
, HDR_ATTRIBUTE15
, HDR_ATTRIBUTE16
, HDR_ATTRIBUTE17
, HDR_ATTRIBUTE18
, HDR_ATTRIBUTE19
, HDR_ATTRIBUTE20
, HDR_ATTRIBUTE21
, HDR_ATTRIBUTE22
, HDR_ATTRIBUTE23
, HDR_ATTRIBUTE24
, HDR_ATTRIBUTE25
, HDR_ATTRIBUTE26
, HDR_ATTRIBUTE27
, HDR_ATTRIBUTE28
, HDR_ATTRIBUTE29
, HDR_ATTRIBUTE30
, CONTACT_EMAIL_ADDRESS
, CONTACT_PHONE
, TRANSACTION_SOURCE
, EFFECTIVE_START_DATE
, DAYS_COVERED
, TRX_CURRENCY
, TRANSACTION_STATUS
, ORG_ID
FROM APPS.DPP_XLA_CLAIM_HEADERS_V;
|
|
|