eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.INL_SHIP_OVERALL_V

Object Details

Object Name:	INL_SHIP_OVERALL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INL.INL_SHIP_OVERALL_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

APPS.INL_SHIP_OVERALL_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES_VL; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; HZ_CUST_ACCT_SITES; HZ_CUST_SITE_USES; HZ_PARTIES; HZ_PARTY_SITES; INL_ADJ_SHIP_LINES_V; INL_SHIP_HEADERS; INL_SHIP_LINES; INL_SHIP_LINE_GROUPS; INL_SHIP_LINE_TYPES_B; INL_SHIP_TYPES_B; MTL_SYSTEM_ITEMS_VL; OE_ORDER_HEADERS; OE_ORDER_LINES; OE_SOLD_TO_ORGS_V; ORG_ORGANIZATION_DEFINITIONS; PO_HEADERS; PO_LINES; PO_LINE_LOCATIONS; PO_RELEASES; PO_REQUISITION_HEADERS; PO_REQUISITION_LINES; PO_VENDORS; PO_VENDOR_SITES; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_SUPPLY; RCV_TRANSACTIONS

APPS.INL_SHIP_OVERALL_V is not referenced by any database object