[Home] [Help] [Dependency Information]
Object Name: | RCV_RECEIPT_CONFIRMATION_HDR_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WAREHOUSE | VARCHAR2 | (3) | Organization code | |
TRANSFER_WAREHOUSE | VARCHAR2 | (3) | Organization code | |
RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | Yes | Source type of the shipment |
SHIPPED_DATE | DATE | Shipping date | ||
VENDOR_NAME | VARCHAR2 | (240) | Supplier name | |
VENDOR_SITE_CODE | VARCHAR2 | (15) | Site code name | |
CUSTOMER_NAME | VARCHAR2 | (360) | ||
ADDRESS1 | VARCHAR2 | (240) | ||
ADDRESS2 | VARCHAR2 | (240) | ||
ADDRESS3 | VARCHAR2 | (240) | ||
ADDRESS4 | VARCHAR2 | (240) | ||
CITY | VARCHAR2 | (60) | ||
PROVINCE | VARCHAR2 | (60) | ||
COUNTY | VARCHAR2 | (60) | ||
POSTAL_CODE | VARCHAR2 | (60) | ||
STATE | VARCHAR2 | (60) | ||
COUNTRY | VARCHAR2 | (60) | ||
TRANSACTION_DATE | DATE | Yes | ||
SHIPMENT_HEADER_ID | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
SHIPMENT_NUM | VARCHAR2 | (30) | ||
RECEIPT_NUM | VARCHAR2 | (30) | ||
RECEIVER_NAME | VARCHAR2 | (240) | ||
SHIP_TO_LOCATION_ID | NUMBER | |||
SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | ||
BILL_OF_LADING | VARCHAR2 | (25) | ||
PACKING_SLIP | VARCHAR2 | (25) | ||
FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | ||
EXPECTED_RECEIPT_DATE | DATE | |||
EMPLOYEE_ID | NUMBER | (9) | ||
NUM_OF_CONTAINERS | NUMBER | |||
WAYBILL_AIRBILL_NUM | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (4000) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ASN_TYPE | VARCHAR2 | (25) | ||
EDI_CONTROL_NUM | VARCHAR2 | (10) | ||
NOTICE_CREATION_DATE | DATE | |||
GROSS_WEIGHT | NUMBER | |||
GROSS_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
NET_WEIGHT | NUMBER | |||
NET_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
TAR_WEIGHT | NUMBER | |||
TAR_WEIGHT_UOM_CODE | VARCHAR2 | (3) | ||
PACKAGING_CODE | VARCHAR2 | (5) | ||
CARRIER_METHOD | VARCHAR2 | (2) | ||
CARRIER_EQUIPMENT | VARCHAR2 | (10) | ||
CARRIER_EQUIPMENT_NUM | VARCHAR2 | (10) | ||
CARRIER_EQUIPMENT_ALPHA | VARCHAR2 | (10) | ||
SPECIAL_HANDLING_CODE | VARCHAR2 | (3) | ||
HAZARD_CODE | VARCHAR2 | (1) | ||
HAZARD_CLASS | VARCHAR2 | (4) | ||
HAZARD_DESCRIPTION | VARCHAR2 | (80) | ||
FREIGHT_TERMS | VARCHAR2 | (25) | ||
FREIGHT_BILL_NUMBER | VARCHAR2 | (35) | ||
INVOICE_NUM | VARCHAR2 | (50) | ||
INVOICE_DATE | DATE | |||
INVOICE_AMOUNT | NUMBER | |||
TAX_NAME | VARCHAR2 | (50) | ||
TAX_AMOUNT | NUMBER | |||
FREIGHT_AMOUNT | NUMBER | |||
INVOICE_STATUS_CODE | VARCHAR2 | (25) | ||
ASN_STATUS | VARCHAR2 | (10) | ||
CURRENCY_CODE | VARCHAR2 | (15) | ||
CONVERSION_RATE_TYPE | VARCHAR2 | (30) | ||
CONVERSION_RATE | NUMBER | |||
CONVERSION_DATE | DATE | |||
PAYMENT_TERMS_ID | NUMBER | |||
MRC_CONVERSION_RATE_TYPE | VARCHAR2 | (2000) | ||
MRC_CONVERSION_DATE | VARCHAR2 | (2000) | ||
MRC_CONVERSION_RATE | VARCHAR2 | (2000) | ||
SHIP_TO_ORG_ID | NUMBER | |||
CUSTOMER_ID | NUMBER | |||
CUSTOMER_SITE_ID | NUMBER | |||
REMIT_TO_SITE_ID | NUMBER | |||
SHIP_FROM_LOCATION_ID | NUMBER | |||
WF_ITEM_TYPE | VARCHAR2 | (8) | ||
WF_ITEM_KEY | VARCHAR2 | (280) | ||
APPROVAL_STATUS | VARCHAR2 | (25) | ||
PERFORMANCE_PERIOD_FROM | DATE | |||
PERFORMANCE_PERIOD_TO | DATE | |||
REQUEST_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT WAREHOUSE
, TRANSFER_WAREHOUSE
, RECEIPT_SOURCE_CODE
, SHIPPED_DATE
, VENDOR_NAME
, VENDOR_SITE_CODE
, CUSTOMER_NAME
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, PROVINCE
, COUNTY
, POSTAL_CODE
, STATE
, COUNTRY
, TRANSACTION_DATE
, SHIPMENT_HEADER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, VENDOR_ID
, VENDOR_SITE_ID
, ORGANIZATION_ID
, SHIPMENT_NUM
, RECEIPT_NUM
, RECEIVER_NAME
, SHIP_TO_LOCATION_ID
, SHIP_TO_LOCATION_CODE
, BILL_OF_LADING
, PACKING_SLIP
, FREIGHT_CARRIER_CODE
, EXPECTED_RECEIPT_DATE
, EMPLOYEE_ID
, NUM_OF_CONTAINERS
, WAYBILL_AIRBILL_NUM
, COMMENTS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ASN_TYPE
, EDI_CONTROL_NUM
, NOTICE_CREATION_DATE
, GROSS_WEIGHT
, GROSS_WEIGHT_UOM_CODE
, NET_WEIGHT
, NET_WEIGHT_UOM_CODE
, TAR_WEIGHT
, TAR_WEIGHT_UOM_CODE
, PACKAGING_CODE
, CARRIER_METHOD
, CARRIER_EQUIPMENT
, CARRIER_EQUIPMENT_NUM
, CARRIER_EQUIPMENT_ALPHA
, SPECIAL_HANDLING_CODE
, HAZARD_CODE
, HAZARD_CLASS
, HAZARD_DESCRIPTION
, FREIGHT_TERMS
, FREIGHT_BILL_NUMBER
, INVOICE_NUM
, INVOICE_DATE
, INVOICE_AMOUNT
, TAX_NAME
, TAX_AMOUNT
, FREIGHT_AMOUNT
, INVOICE_STATUS_CODE
, ASN_STATUS
, CURRENCY_CODE
, CONVERSION_RATE_TYPE
, CONVERSION_RATE
, CONVERSION_DATE
, PAYMENT_TERMS_ID
, MRC_CONVERSION_RATE_TYPE
, MRC_CONVERSION_DATE
, MRC_CONVERSION_RATE
, SHIP_TO_ORG_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, REMIT_TO_SITE_ID
, SHIP_FROM_LOCATION_ID
, WF_ITEM_TYPE
, WF_ITEM_KEY
, APPROVAL_STATUS
, PERFORMANCE_PERIOD_FROM
, PERFORMANCE_PERIOD_TO
, REQUEST_DATE
FROM APPS.RCV_RECEIPT_CONFIRMATION_HDR_V;
APPS.RCV_RECEIPT_CONFIRMATION_HDR_V is not referenced by any database object
|
|
|