[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | RCV_HEADERS_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | PO |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| HEADER_INTERFACE_ID | NUMBER | Yes | ||
| GROUP_ID | NUMBER | |||
| EDI_CONTROL_NUM | VARCHAR2 | (10) | ||
| PROCESSING_STATUS_CODE | VARCHAR2 | (25) | ||
| RECEIPT_SOURCE_CODE | VARCHAR2 | (25) | ||
| ASN_TYPE | VARCHAR2 | (25) | ||
| TRANSACTION_TYPE | VARCHAR2 | (25) | ||
| AUTO_TRANSACT_CODE | VARCHAR2 | (25) | ||
| TEST_FLAG | VARCHAR2 | (1) | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | |||
| NOTICE_CREATION_DATE | DATE | |||
| SHIPMENT_NUM | VARCHAR2 | (30) | ||
| RECEIPT_NUM | VARCHAR2 | (30) | ||
| RECEIPT_HEADER_ID | NUMBER | |||
| VENDOR_NAME | VARCHAR2 | (240) | ||
| VENDOR_NUM | VARCHAR2 | (30) | ||
| VENDOR_ID | NUMBER | |||
| VENDOR_SITE_CODE | VARCHAR2 | (35) | ||
| VENDOR_SITE_ID | NUMBER | |||
| FROM_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| FROM_ORGANIZATION_ID | NUMBER | |||
| SHIP_TO_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
| SHIP_TO_ORGANIZATION_ID | NUMBER | |||
| LOCATION_CODE | VARCHAR2 | (60) | ||
| LOCATION_ID | NUMBER | |||
| BILL_OF_LADING | VARCHAR2 | (25) | ||
| PACKING_SLIP | VARCHAR2 | (25) | ||
| SHIPPED_DATE | DATE | |||
| FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | ||
| EXPECTED_RECEIPT_DATE | DATE | |||
| RECEIVER_ID | NUMBER | |||
| NUM_OF_CONTAINERS | NUMBER | |||
| WAYBILL_AIRBILL_NUM | VARCHAR2 | (30) | ||
| COMMENTS | VARCHAR2 | (240) | ||
| 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) | ||
| 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 | (30) | ||
| INVOICE_DATE | DATE | |||
| TOTAL_INVOICE_AMOUNT | NUMBER | |||
| TAX_NAME | VARCHAR2 | (50) | ||
| TAX_AMOUNT | NUMBER | |||
| FREIGHT_AMOUNT | NUMBER | |||
| CURRENCY_CODE | VARCHAR2 | (15) | ||
| CONVERSION_RATE_TYPE | VARCHAR2 | (30) | ||
| CONVERSION_RATE | NUMBER | |||
| CONVERSION_RATE_DATE | DATE | |||
| PAYMENT_TERMS_NAME | VARCHAR2 | (50) | ||
| PAYMENT_TERMS_ID | NUMBER | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| USGGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
| EMPLOYEE_NAME | VARCHAR2 | (240) | ||
| EMPLOYEE_ID | NUMBER | |||
| INVOICE_STATUS_CODE | VARCHAR2 | (25) | ||
| VALIDATION_FLAG | VARCHAR2 | (1) | ||
| PROCESSING_REQUEST_ID | NUMBER | |||
| CUSTOMER_ACCOUNT_NUMBER | NUMBER | |||
| CUSTOMER_ID | NUMBER | |||
| CUSTOMER_SITE_ID | NUMBER | |||
| CUSTOMER_PARTY_NAME | VARCHAR2 | (360) | ||
| REMIT_TO_SITE_ID | NUMBER | |||
| TRANSACTION_DATE | DATE | |||
| ORG_ID | NUMBER | |||
| OPERATING_UNIT | VARCHAR2 | (240) | ||
| SHIP_FROM_LOCATION_ID | NUMBER | |||
| PERFORMANCE_PERIOD_FROM | DATE | |||
| PERFORMANCE_PERIOD_TO | DATE | |||
| REQUEST_DATE | DATE | |||
| SHIP_FROM_LOCATION_CODE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_INTERFACE_ID
, GROUP_ID
, EDI_CONTROL_NUM
, PROCESSING_STATUS_CODE
, RECEIPT_SOURCE_CODE
, ASN_TYPE
, TRANSACTION_TYPE
, AUTO_TRANSACT_CODE
, TEST_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, NOTICE_CREATION_DATE
, SHIPMENT_NUM
, RECEIPT_NUM
, RECEIPT_HEADER_ID
, VENDOR_NAME
, VENDOR_NUM
, VENDOR_ID
, VENDOR_SITE_CODE
, VENDOR_SITE_ID
, FROM_ORGANIZATION_CODE
, FROM_ORGANIZATION_ID
, SHIP_TO_ORGANIZATION_CODE
, SHIP_TO_ORGANIZATION_ID
, LOCATION_CODE
, LOCATION_ID
, BILL_OF_LADING
, PACKING_SLIP
, SHIPPED_DATE
, FREIGHT_CARRIER_CODE
, EXPECTED_RECEIPT_DATE
, RECEIVER_ID
, NUM_OF_CONTAINERS
, WAYBILL_AIRBILL_NUM
, COMMENTS
, GROSS_WEIGHT
, GROSS_WEIGHT_UOM_CODE
, NET_WEIGHT
, NET_WEIGHT_UOM_CODE
, TAR_WEIGHT
, TAR_WEIGHT_UOM_CODE
, PACKAGING_CODE
, CARRIER_METHOD
, CARRIER_EQUIPMENT
, SPECIAL_HANDLING_CODE
, HAZARD_CODE
, HAZARD_CLASS
, HAZARD_DESCRIPTION
, FREIGHT_TERMS
, FREIGHT_BILL_NUMBER
, INVOICE_NUM
, INVOICE_DATE
, TOTAL_INVOICE_AMOUNT
, TAX_NAME
, TAX_AMOUNT
, FREIGHT_AMOUNT
, CURRENCY_CODE
, CONVERSION_RATE_TYPE
, CONVERSION_RATE
, CONVERSION_RATE_DATE
, PAYMENT_TERMS_NAME
, PAYMENT_TERMS_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, USGGL_TRANSACTION_CODE
, EMPLOYEE_NAME
, EMPLOYEE_ID
, INVOICE_STATUS_CODE
, VALIDATION_FLAG
, PROCESSING_REQUEST_ID
, CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, CUSTOMER_PARTY_NAME
, REMIT_TO_SITE_ID
, TRANSACTION_DATE
, ORG_ID
, OPERATING_UNIT
, SHIP_FROM_LOCATION_ID
, PERFORMANCE_PERIOD_FROM
, PERFORMANCE_PERIOD_TO
, REQUEST_DATE
, SHIP_FROM_LOCATION_CODE
FROM PO.RCV_HEADERS_INTERFACE#;
PO
RCV_HEADERS_INTERFACE
APPS
RCV_HEADERS_INTERFACE
|
|
|
|