[Home] [Help] [Dependency Information]
Object Name: | PA_CI_SUPPLIER_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PA.PA_CI_SUPPLIER_DETAILS_V |
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 |
---|---|---|---|---|
ROW_NUMBER | ROWID | (10) | ||
CI_TRANSACTION_ID | NUMBER | (15) | ||
CI_TYPE_ID | NUMBER | (15) | ||
CI_ID | NUMBER | (15) | ||
VENDOR_ID | NUMBER | (15) | ||
PO_HEADER_ID | NUMBER | (15) | ||
PO_LINE_ID | NUMBER | (15) | ||
ADJUSTED_CI_TRANSACTION_ID | NUMBER | (15) | ||
CHANGE_TYPE | VARCHAR2 | (100) | ||
CHANGE_DESCRIPTION | VARCHAR2 | (2000) | ||
CREATED_BY | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CHANGE_AMOUNT | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
PO_NUMBER | VARCHAR2 | (20) | ||
PO_LINE_NUM | NUMBER | |||
VENDOR_NAME | VARCHAR2 | (240) | ||
CI_STATUS | VARCHAR2 | (100) | ||
PO_ORG_ID | NUMBER | |||
PROJECT_ID | NUMBER | (15) | ||
ORIGINAL_SUPP_TRANS_ID | NUMBER | |||
CI_TYPE_CLASS_CODE | VARCHAR2 | (30) | ||
TASK_ID | NUMBER | (15) | ||
RES_ID | NUMBER | (15) | ||
EXP_ID | NUMBER | (15) | ||
EST_AMT | NUMBER | |||
QTD_AMT | NUMBER | |||
NEG_AMT | NUMBER | |||
MARK_AMT | NUMBER | |||
FINAL_AMT | NUMBER | |||
STATUS | VARCHAR2 | (15) | ||
FROM_CHANGE_DATE | DATE | |||
TO_CHANGE_DATE | DATE | |||
RAW_COST | NUMBER | |||
BURDENED_COST | NUMBER | |||
REVENUE_RATE | NUMBER | |||
REVENUE_OVERRIDE_RATE | NUMBER | |||
REVENUE | NUMBER | |||
TOTAL_REVENUE | NUMBER | |||
TASK_NAME | VARCHAR2 | (20) | ||
RESOURCE_NAME | VARCHAR2 | (80) | ||
SUPPLIER_QUOTE_REF_NO | NUMBER | |||
EXPENDITURE_ORG_ID | NUMBER | (15) | ||
CHANGE_REASON_CODE | VARCHAR2 | (30) | ||
QUOTE_NEGOTIATION_REFERENCE | VARCHAR2 | (150) | ||
NEED_BY_DATE | DATE | |||
EXPENDITURE_TYPE | VARCHAR2 | (30) | ||
RESOURCE_ASSIGNMENT_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_NUMBER
, CI_TRANSACTION_ID
, CI_TYPE_ID
, CI_ID
, VENDOR_ID
, PO_HEADER_ID
, PO_LINE_ID
, ADJUSTED_CI_TRANSACTION_ID
, CHANGE_TYPE
, CHANGE_DESCRIPTION
, CREATED_BY
, CURRENCY_CODE
, CHANGE_AMOUNT
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PO_NUMBER
, PO_LINE_NUM
, VENDOR_NAME
, CI_STATUS
, PO_ORG_ID
, PROJECT_ID
, ORIGINAL_SUPP_TRANS_ID
, CI_TYPE_CLASS_CODE
, TASK_ID
, RES_ID
, EXP_ID
, EST_AMT
, QTD_AMT
, NEG_AMT
, MARK_AMT
, FINAL_AMT
, STATUS
, FROM_CHANGE_DATE
, TO_CHANGE_DATE
, RAW_COST
, BURDENED_COST
, REVENUE_RATE
, REVENUE_OVERRIDE_RATE
, REVENUE
, TOTAL_REVENUE
, TASK_NAME
, RESOURCE_NAME
, SUPPLIER_QUOTE_REF_NO
, EXPENDITURE_ORG_ID
, CHANGE_REASON_CODE
, QUOTE_NEGOTIATION_REFERENCE
, NEED_BY_DATE
, EXPENDITURE_TYPE
, RESOURCE_ASSIGNMENT_ID
FROM APPS.PA_CI_SUPPLIER_DETAILS_V;
|
|
|