[Home] [Help]
[Dependency Information]
Object Name: | PA_VRM_SOURCE_DOCUMENT |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | |||
DOC_ID_INT_1 | NUMBER | (15) | Yes | |
DOCUMENT_DATE | DATE | |||
DOCUMENT_NUMBER | VARCHAR2 | (25) | Yes | |
DOCUMENT_TYPE | VARCHAR2 | (9) | ||
DOCUMENT_CREATION_DATE | DATE | Yes | ||
DOCUMENT_UPDATE_DATE | DATE | Yes | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
BILL_TO_CUSTOMER_PARTY_ID | NUMBER | (15) | Yes | |
BILL_TO_CUSTOMER_PARTY_NUM | VARCHAR2 | (30) | Yes | |
BILL_TO_CUSTOMER_PARTY_NAME | VARCHAR2 | (360) | Yes | |
BILL_TO_CUSTOMER_ID | NUMBER | (15) | Yes | |
SHIP_TO_CUSTOMER_ID | NUMBER | (15) | Yes | |
BILL_TO_CUSTOMER_NUM | VARCHAR2 | (30) | Yes | |
SHIP_TO_CUSTOMER_NUM | VARCHAR2 | (30) | Yes | |
BILL_TO_CUSTOMER_NAME | VARCHAR2 | (240) | ||
SHIP_TO_CUSTOMER_NAME | VARCHAR2 | (240) | ||
BILL_TO_CUSTOMER_SITE_ID | NUMBER | (15) | ||
BILL_TO_CUST_SITE_NAME | VARCHAR2 | (240) | ||
SHIP_TO_CUSTOMER_SITE_ID | NUMBER | (15) | ||
SHIP_TO_CUST_SITE_NAME | VARCHAR2 | (240) | ||
BILL_TO_COUNTRY | VARCHAR2 | (60) | Yes | |
SHIP_TO_COUNTRY | VARCHAR2 | (60) | Yes | |
ORG_ID | NUMBER | (15) | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | |
LEDGER_ID | NUMBER | (15) | Yes | |
LEDGER_NAME | VARCHAR2 | (30) | Yes | |
LEGAL_ENTITY_ID | NUMBER | (15) | Yes | |
LEGAL_ENTITY_NAME | VARCHAR2 | (240) | Yes | |
LEGAL_ENTITY_COUNTRY | VARCHAR2 | (60) | ||
LEGAL_ENTITY_ADDRESS | VARCHAR2 | (240) | ||
OPEN_FLAG | VARCHAR2 | (1) | ||
BILL_TO_CUSTOMER_STATE | VARCHAR2 | (60) | ||
BILL_TO_CUSTOMER_COUNTY | VARCHAR2 | (60) | ||
BILL_TO_CUSTOMER_CITY | VARCHAR2 | (60) | ||
BILL_TO_CUSTOMER_POSTAL_CODE | VARCHAR2 | (60) | ||
BILL_TO_CUST_CLASSIFICATION | VARCHAR2 | (30) | ||
SRC_ATTRIBUTE_CHAR1 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR2 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR3 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR4 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR5 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR6 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR7 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR8 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR9 | VARCHAR2 | (150) | ||
SRC_ATTRIBUTE_CHAR10 | VARCHAR2 | (150) | ||
OBJECT_VERSION_NUMBER | NUMBER | |||
ACCOUNTING_EFFECT_FLAG | CHAR | (1) | ||
CREATED_BY | VARCHAR2 | (100) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | VARCHAR2 | (100) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | |
SOURCE_BILL_TO_CUST_SITE_NUM | VARCHAR2 | (30) | Yes | |
SOURCE_BILL_TO_CUST_ADDRESS | VARCHAR2 | (1085) | ||
SOURCE_SHIP_TO_CUST_SITE_NUM | VARCHAR2 | (30) | Yes | |
SOURCE_SHIP_TO_CUST_ADDRESS | VARCHAR2 | (1085) |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, DOC_ID_INT_1
, DOCUMENT_DATE
, DOCUMENT_NUMBER
, DOCUMENT_TYPE
, DOCUMENT_CREATION_DATE
, DOCUMENT_UPDATE_DATE
, CURRENCY_CODE
, BILL_TO_CUSTOMER_PARTY_ID
, BILL_TO_CUSTOMER_PARTY_NUM
, BILL_TO_CUSTOMER_PARTY_NAME
, BILL_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_ID
, BILL_TO_CUSTOMER_NUM
, SHIP_TO_CUSTOMER_NUM
, BILL_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NAME
, BILL_TO_CUSTOMER_SITE_ID
, BILL_TO_CUST_SITE_NAME
, SHIP_TO_CUSTOMER_SITE_ID
, SHIP_TO_CUST_SITE_NAME
, BILL_TO_COUNTRY
, SHIP_TO_COUNTRY
, ORG_ID
, ORGANIZATION_NAME
, LEDGER_ID
, LEDGER_NAME
, LEGAL_ENTITY_ID
, LEGAL_ENTITY_NAME
, LEGAL_ENTITY_COUNTRY
, LEGAL_ENTITY_ADDRESS
, OPEN_FLAG
, BILL_TO_CUSTOMER_STATE
, BILL_TO_CUSTOMER_COUNTY
, BILL_TO_CUSTOMER_CITY
, BILL_TO_CUSTOMER_POSTAL_CODE
, BILL_TO_CUST_CLASSIFICATION
, SRC_ATTRIBUTE_CHAR1
, SRC_ATTRIBUTE_CHAR2
, SRC_ATTRIBUTE_CHAR3
, SRC_ATTRIBUTE_CHAR4
, SRC_ATTRIBUTE_CHAR5
, SRC_ATTRIBUTE_CHAR6
, SRC_ATTRIBUTE_CHAR7
, SRC_ATTRIBUTE_CHAR8
, SRC_ATTRIBUTE_CHAR9
, SRC_ATTRIBUTE_CHAR10
, OBJECT_VERSION_NUMBER
, ACCOUNTING_EFFECT_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SOURCE_BILL_TO_CUST_SITE_NUM
, SOURCE_BILL_TO_CUST_ADDRESS
, SOURCE_SHIP_TO_CUST_SITE_NUM
, SOURCE_SHIP_TO_CUST_ADDRESS
FROM APPS.PA_VRM_SOURCE_DOCUMENT;
APPS.PA_VRM_SOURCE_DOCUMENT is not referenced by any database object
|
|
|