[Home] [Help] [Dependency Information]
Object Name: | INL_SHIP_OVERALL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INL.INL_SHIP_OVERALL_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view shows overall information on Shipments and their sources such as Purchase Orders, Internal Requisitions and RMA.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIP_HEADER_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
LOCATION_ID | NUMBER | |||
ORG_ID | NUMBER | |||
SHIP_TYPE_ID | NUMBER | |||
SHIP_TYPE_CODE | VARCHAR2 | (15) | ||
SHIP_NUM | VARCHAR2 | (25) | ||
SHIP_DATE | DATE | |||
SHIP_STATUS_CODE | VARCHAR2 | (30) | ||
PENDING_MATCHING_FLAG | VARCHAR2 | (1) | ||
SHIP_LINE_GROUP_ID | NUMBER | Line Group Identifier | ||
SHIP_LINE_GROUP_NUM | NUMBER | Line Group Number | ||
SHIP_LINE_GROUP_REFERENCE | VARCHAR2 | (30) | Line Group Reference | |
SRC_TYPE_CODE | VARCHAR2 | (30) | Source Type Code | |
GROUP_PARTY_ID | NUMBER | Group Party Identifier | ||
GROUP_PARTY_NAME | VARCHAR2 | (360) | Group Party Name | |
GROUP_PARTY_SITE_ID | NUMBER | Group Party Site Identifier | ||
GROUP_PARTY_SITE_NAME | VARCHAR2 | (240) | Group Party Site Name | |
GROUP_ORGANIZATION_ID | NUMBER | Group Inventory Organization Identifier | ||
GROUP_ORGANIZATION_NAME | VARCHAR2 | (240) | Group Inventory Organization Name | |
SHIP_LINE_ID | NUMBER | Shipment Line Identifier | ||
SHIP_LINE_NUM | NUMBER | Shipment Line Number | ||
EST_SHIP_LINE_ID | NUMBER | Estimated Shipment Line Identifier | ||
EST_TXN_UNIT_PRICE | NUMBER | Estimated Transaction Unit Price | ||
SHIP_LINE_SRC_TYPE_CODE | VARCHAR2 | (30) | Source Type Code, taken from lookup INL_SHIP_LINE_SRC_TYPES | |
SHIP_LINE_SOURCE_ID | NUMBER | Source Identifier, according to the Source Type Code | ||
SHIP_LINE_TYPE_CODE | VARCHAR2 | (15) | Shipment Line Type Code | |
ITEM_ID | NUMBER | Inventory Item Identifier | ||
ITEM | VARCHAR2 | (40) | Inventory Item Segment 1 | |
ITEM_REVISION | VARCHAR2 | (3) | Inventory Item Revision | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Inventory Item Description | |
TXN_QTY | NUMBER | Transaction Quantity | ||
TXN_UOM_CODE | VARCHAR2 | (3) | Transaction Unit of Measure | |
PRIMARY_UOM_CODE | VARCHAR2 | (3) | Primary Unit of Measure Code | |
PRIMARY_QTY | NUMBER | Primary Quantity | ||
SECONDARY_UOM_CODE | VARCHAR2 | (3) | Secondary Unit of Measure | |
SECONDARY_QTY | NUMBER | Secondary Quantity | ||
TXN_UNIT_PRICE | NUMBER | Transaction Unit Price | ||
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency Conversion Type | |
CURRENCY_CONVERSION_DATE | DATE | Currency Conversion Date | ||
CURRENCY_CONVERSION_RATE | NUMBER | Currency Conversion Rate | ||
LINE_AMT | NUMBER | Line Amount | ||
SRC_ID | NUMBER | Source Identifier | ||
SRC_TYPE | VARCHAR2 | (80) | Source Type Code | |
SRC_NUMBER | VARCHAR2 | (40) | Source Number | |
SRC_DESCRIPTION | VARCHAR2 | (240) | Source Description | |
SRC_ORG_ID | NUMBER | Source Operating Unit | ||
SRC_PARTY_ID | NUMBER | Source Party Identifier | ||
SRC_PARTY_NAME | VARCHAR2 | (360) | Source Party Name | |
SRC_PARTY_SITE_ID | NUMBER | Source Party Site Identifier | ||
SRC_PARTY_SITE_NAME | VARCHAR2 | (240) | Source Party Site Name | |
SRC_VENDOR_ID | NUMBER | Source Vendor Identifier | ||
SRC_VENDOR_NAME | VARCHAR2 | (240) | Source Vendor Name | |
SRC_VENDOR_SITE_ID | NUMBER | Source Vendor Site Identifier | ||
SRC_VENDOR_SITE_CODE | VARCHAR2 | (15) | Source Vendor Site Code | |
SRC_ORGANIZATION_ID | NUMBER | Source Inventory Organization Identifier | ||
SRC_LOCATION_ID | NUMBER | Source Location Identifier | ||
SRC_CUSTOMER_ID | NUMBER | Source Customer Identifier | ||
SRC_CUSTOMER_NAME | VARCHAR2 | (360) | Source Customer Name | |
SRC_CUSTOMER_NUMBER | VARCHAR2 | (30) | Source Customer Number | |
SRC_CUSTOMER_SITE_CODE | VARCHAR2 | (30) | Source Customer Site Code | |
SRC_CUST_ITEM_NUM | VARCHAR2 | (0) | Source Customer Item Number | |
SRC_RELEASE_NUM | NUMBER | Source Release Number | ||
SRC_RELEASE_ID | NUMBER | Source Release Identitier | ||
SRC_RELEASE_DATE | DATE | Source Release Date | ||
SRC_LINE_ID | NUMBER | Source Line Identifier | ||
SRC_LINE_NUM | NUMBER | Source Line Number | ||
SRC_SHIP_ID | NUMBER | Source Shipment Identifier | ||
SRC_SHIP_NUM | VARCHAR2 | (40) | Source Shipment Number | |
SRC_SHIPPED_DATE | DATE | Source Shipped Date | ||
SRC_QTY | NUMBER | Source Quantity | ||
SRC_ITEM_ID | NUMBER | Source Item Identifier | ||
SRC_ITEM_REVISION | VARCHAR2 | (3) | Source Item Revision | |
SRC_ITEM_DESCRIPTION | VARCHAR2 | (240) | Source Item Description | |
SRC_CONTAINER_NUM | VARCHAR2 | (35) | Source Customer Identifier | |
SRC_TRUCK_NUM | VARCHAR2 | (35) | Source Truck Number | |
SRC_BAR_CODE_LABEL | VARCHAR2 | (35) | Source Bar Code Label | |
SRC_DELIVER_TO_PERSON_ID | NUMBER | Source Deliver To Person Identifier | ||
SRC_VENDOR_ITEM_NUM | VARCHAR2 | (25) | Source Vendor Item Number | |
SRC_PACKING_SLIP | VARCHAR2 | (25) | Source Packing Slip | |
SRC_EMPLOYEE_ID | NUMBER | Source Employee Identifier | ||
SRC_FREIGHT_CARRIER_CODE | VARCHAR2 | (25) | Source Freight Carrier Code | |
SRC_BILL_OF_LADING | VARCHAR2 | (25) | Source Container Number | |
SRC_ROUTING_ID | NUMBER | Source Routing Identifier | ||
SRC_INSPECTION_STATUS_CODE | VARCHAR2 | (25) | Source Inspection Status Code | |
SRC_TRANSACTION_DATE | DATE | Source Transaction Date |
Cut, paste (and edit) the following text to query this object:
SELECT SHIP_HEADER_ID
, ORGANIZATION_ID
, LOCATION_ID
, ORG_ID
, SHIP_TYPE_ID
, SHIP_TYPE_CODE
, SHIP_NUM
, SHIP_DATE
, SHIP_STATUS_CODE
, PENDING_MATCHING_FLAG
, SHIP_LINE_GROUP_ID
, SHIP_LINE_GROUP_NUM
, SHIP_LINE_GROUP_REFERENCE
, SRC_TYPE_CODE
, GROUP_PARTY_ID
, GROUP_PARTY_NAME
, GROUP_PARTY_SITE_ID
, GROUP_PARTY_SITE_NAME
, GROUP_ORGANIZATION_ID
, GROUP_ORGANIZATION_NAME
, SHIP_LINE_ID
, SHIP_LINE_NUM
, EST_SHIP_LINE_ID
, EST_TXN_UNIT_PRICE
, SHIP_LINE_SRC_TYPE_CODE
, SHIP_LINE_SOURCE_ID
, SHIP_LINE_TYPE_CODE
, ITEM_ID
, ITEM
, ITEM_REVISION
, ITEM_DESCRIPTION
, TXN_QTY
, TXN_UOM_CODE
, PRIMARY_UOM_CODE
, PRIMARY_QTY
, SECONDARY_UOM_CODE
, SECONDARY_QTY
, TXN_UNIT_PRICE
, CURRENCY_CODE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE
, LINE_AMT
, SRC_ID
, SRC_TYPE
, SRC_NUMBER
, SRC_DESCRIPTION
, SRC_ORG_ID
, SRC_PARTY_ID
, SRC_PARTY_NAME
, SRC_PARTY_SITE_ID
, SRC_PARTY_SITE_NAME
, SRC_VENDOR_ID
, SRC_VENDOR_NAME
, SRC_VENDOR_SITE_ID
, SRC_VENDOR_SITE_CODE
, SRC_ORGANIZATION_ID
, SRC_LOCATION_ID
, SRC_CUSTOMER_ID
, SRC_CUSTOMER_NAME
, SRC_CUSTOMER_NUMBER
, SRC_CUSTOMER_SITE_CODE
, SRC_CUST_ITEM_NUM
, SRC_RELEASE_NUM
, SRC_RELEASE_ID
, SRC_RELEASE_DATE
, SRC_LINE_ID
, SRC_LINE_NUM
, SRC_SHIP_ID
, SRC_SHIP_NUM
, SRC_SHIPPED_DATE
, SRC_QTY
, SRC_ITEM_ID
, SRC_ITEM_REVISION
, SRC_ITEM_DESCRIPTION
, SRC_CONTAINER_NUM
, SRC_TRUCK_NUM
, SRC_BAR_CODE_LABEL
, SRC_DELIVER_TO_PERSON_ID
, SRC_VENDOR_ITEM_NUM
, SRC_PACKING_SLIP
, SRC_EMPLOYEE_ID
, SRC_FREIGHT_CARRIER_CODE
, SRC_BILL_OF_LADING
, SRC_ROUTING_ID
, SRC_INSPECTION_STATUS_CODE
, SRC_TRANSACTION_DATE
FROM APPS.INL_SHIP_OVERALL_V;
APPS.INL_SHIP_OVERALL_V is not referenced by any database object
|
|
|