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.POBV_INBOUND_SHIPMENT_LINES

Object Details

Object Name:	POBV_INBOUND_SHIPMENT_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POBV_INBOUND_SHIPMENT_LINES
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows receiving information for items that have been shipped and/or received from a specific receipt source.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SHIPMENT_LINE_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
RECEIVED_QUANTITY	NUMBER
SHIPPED_QUANTITY	NUMBER
EDI_UNIT_PRICE	NUMBER
SHIPMENT_UNIT_PRICE	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
COMMENTS	VARCHAR2	(4000)
SHIPMENT_LINE_STATUS	VARCHAR2	(25)
_LA:ASN_LINE_FLAG	CHAR	(59)
BAR_CODE_LABEL	VARCHAR2	(35)
CONTAINER_NUMBER	VARCHAR2	(35)
_LA:DESTINATION_TYPE	CHAR	(77)
PACKING_SLIP_NUMBER	VARCHAR2	(25)
_LA:SOURCE_DOCUMENT_TYPE	CHAR	(89)
SUPPLIER_ITEM_NUMBER	VARCHAR2	(25)
SUPPLIER_LOT_NUMBER	VARCHAR2	(30)
SUPPLIER_SHIPPED_QUANTITY	NUMBER
TRANSFER_COST	NUMBER
TRANSFER_PERCENTAGE	NUMBER
TRUCK_NUMBER	VARCHAR2	(35)
TRANSACTION_REASON_NAME	VARCHAR2	(30)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
SHIPMENT_ID	NUMBER		Yes
ITEM_ID	NUMBER
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
PURCHASE_ORDER_ID	NUMBER
PO_RELEASE_ID	NUMBER
PO_LINE_ID	NUMBER
PO_SHIPMENT_ID	NUMBER
PO_DISTRIBUTION_ID	NUMBER
REQUISITION_LINE_ID	NUMBER
REQ_DISTRIBUTION_ID	NUMBER
RECEIVING_ROUTING_ID	NUMBER
SOURCE_ORGANIZATION_ID	NUMBER
DESTINATION_ORGANIZATION_ID	NUMBER
DESTINATION_SUBINVENTORY	VARCHAR2	(10)
DELIVER_TO_LOCATION_ID	NUMBER
DELIVER_TO_PERSON_ID	NUMBER	(9)
SHIP_TO_LOCATION_ID	NUMBER
CHARGE_ACCOUNT_ID	NUMBER
TRANSPORTATION_ACCOUNT_ID	NUMBER
SHIPMENT_UNIT_OF_MEASURE	VARCHAR2	(25)
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)
CREATED_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SECONDARY_QUANTITY_SHIPPED	NUMBER
SECONDARY_QUANTITY_RECEIVED	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
QC_GRADE	VARCHAR2	(150)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SHIPMENT_LINE_ID
,      LINE_NUMBER
,      RECEIVED_QUANTITY
,      SHIPPED_QUANTITY
,      EDI_UNIT_PRICE
,      SHIPMENT_UNIT_PRICE
,      ITEM_DESCRIPTION
,      COMMENTS
,      SHIPMENT_LINE_STATUS
,      _LA:ASN_LINE_FLAG
,      BAR_CODE_LABEL
,      CONTAINER_NUMBER
,      _LA:DESTINATION_TYPE
,      PACKING_SLIP_NUMBER
,      _LA:SOURCE_DOCUMENT_TYPE
,      SUPPLIER_ITEM_NUMBER
,      SUPPLIER_LOT_NUMBER
,      SUPPLIER_SHIPPED_QUANTITY
,      TRANSFER_COST
,      TRANSFER_PERCENTAGE
,      TRUCK_NUMBER
,      TRANSACTION_REASON_NAME
,      USSGL_TRANSACTION_CODE
,      SHIPMENT_ID
,      ITEM_ID
,      ITEM_REVISION
,      CATEGORY_ID
,      PURCHASE_ORDER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_SHIPMENT_ID
,      PO_DISTRIBUTION_ID
,      REQUISITION_LINE_ID
,      REQ_DISTRIBUTION_ID
,      RECEIVING_ROUTING_ID
,      SOURCE_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_SUBINVENTORY
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_PERSON_ID
,      SHIP_TO_LOCATION_ID
,      CHARGE_ACCOUNT_ID
,      TRANSPORTATION_ACCOUNT_ID
,      SHIPMENT_UNIT_OF_MEASURE
,      PRIMARY_UNIT_OF_MEASURE
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      SECONDARY_QUANTITY_SHIPPED
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
FROM APPS.POBV_INBOUND_SHIPMENT_LINES;

Dependencies

[top of page]

APPS.POBV_INBOUND_SHIPMENT_LINES references the following:

APPS: MTL_TRANSACTION_REASONS; RCV_SHIPMENT_LINES

APPS.POBV_INBOUND_SHIPMENT_LINES is not referenced by any database object