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

Object Details

Object Name:	POFV_INBOUND_SHIPMENT_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POFV_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)
_DF	CHAR	(28)
SHIPMENT_ID	NUMBER		Yes
SUPPLIER_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(240)
ITEM_ID	NUMBER
_KF:ITEM_NUMBER::_CO	CHAR	(15)
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
_KF:CATEGORY::_CO	CHAR	(15)
OPERATING_UNIT_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)
PURCHASE_ORDER_ID	NUMBER
PURCHASE_ORDER_NUMBER	VARCHAR2	(20)
_LA:PURCHASE_ORDER_TYPE	CHAR	(72)
PO_RELEASE_ID	NUMBER
PO_RELEASE_NUMBER	NUMBER
PO_LINE_ID	NUMBER
PO_LINE_NUMBER	NUMBER
PO_SHIPMENT_ID	NUMBER
PO_SHIPMENT_NUMBER	NUMBER
_LA:PO_SHIPMENT_TYPE	CHAR	(66)
PO_DISTRIBUTION_ID	NUMBER
PO_DISTRIBUTION_NUMBER	NUMBER
REQUISITION_LINE_ID	NUMBER
REQUISITION_DOCUMENT_NUMBER	VARCHAR2	(20)
REQUISITION_LINE_NUMBER	NUMBER
REQ_DISTRIBUTION_ID	NUMBER
REQ_DISTRIBUTION_NUMBER	NUMBER
RECEIVING_ROUTING_ID	NUMBER
RECEIVING_ROUTING_NAME	VARCHAR2	(80)
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_ORGANIZATION_CODE	VARCHAR2	(3)
SOURCE_ORGANIZATION_NAME	VARCHAR2	(240)
DESTINATION_ORGANIZATION_ID	NUMBER
DESTINATION_ORGANIZATION_CODE	VARCHAR2	(3)
DESTINATION_ORGANIZATION_NAME	VARCHAR2	(240)
DESTINATION_SUBINVENTORY	VARCHAR2	(10)
DELIVER_TO_LOCATION_ID	NUMBER
DELIVER_TO_LOCATION	VARCHAR2	(60)
DELIVER_TO_PERSON_ID	NUMBER	(9)
DELIVER_TO_PERSON	VARCHAR2	(240)
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_LOCATION	VARCHAR2	(60)
CHARGE_ACCOUNT_ID	NUMBER
_KF:ACCOUNT_NUM:CHARGE:_CO	CHAR	(16)
TRANSPORTATION_ACCOUNT_ID	NUMBER
_KF:ACCOUNT_NUM:TRANS:_CO	CHAR	(16)
SHIPMENT_UNIT_OF_MEASURE	VARCHAR2	(25)
SHIPMENT_UOM_CLASS	VARCHAR2	(10)
SHIPMENT_UOM_DESCRIPTION	VARCHAR2	(50)
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)
PRIMARY_UOM_CLASS	VARCHAR2	(10)
PRIMARY_UOM_DESCRIPTION	VARCHAR2	(50)
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)
DROP_SHIP_FLAG	VARCHAR2	(1)		Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE	DATE			The date/time when any of referenced data elements on the backing Sales Order Line is updated.

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
,      _DF
,      SHIPMENT_ID
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      ITEM_ID
,      _KF:ITEM_NUMBER::_CO
,      ITEM_REVISION
,      CATEGORY_ID
,      _KF:CATEGORY::_CO
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      PURCHASE_ORDER_ID
,      PURCHASE_ORDER_NUMBER
,      _LA:PURCHASE_ORDER_TYPE
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_SHIPMENT_ID
,      PO_SHIPMENT_NUMBER
,      _LA:PO_SHIPMENT_TYPE
,      PO_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUMBER
,      REQUISITION_LINE_ID
,      REQUISITION_DOCUMENT_NUMBER
,      REQUISITION_LINE_NUMBER
,      REQ_DISTRIBUTION_ID
,      REQ_DISTRIBUTION_NUMBER
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_NAME
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_NAME
,      DESTINATION_SUBINVENTORY
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      CHARGE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:CHARGE:_CO
,      TRANSPORTATION_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:TRANS:_CO
,      SHIPMENT_UNIT_OF_MEASURE
,      SHIPMENT_UOM_CLASS
,      SHIPMENT_UOM_DESCRIPTION
,      PRIMARY_UNIT_OF_MEASURE
,      PRIMARY_UOM_CLASS
,      PRIMARY_UOM_DESCRIPTION
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      SECONDARY_QUANTITY_SHIPPED
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
FROM APPS.POFV_INBOUND_SHIPMENT_LINES;

Dependencies

[top of page]

APPS.POFV_INBOUND_SHIPMENT_LINES references the following:

APPS: GL_CODE_COMBINATIONS; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_CATEGORIES; MTL_ITEM_REVISIONS; MTL_PARAMETERS; MTL_SECONDARY_INVENTORIES; MTL_SYSTEM_ITEMS; MTL_TRANSACTION_REASONS; MTL_UNITS_OF_MEASURE; PER_PEOPLE_F; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_REQ_DISTRIBUTIONS_ALL; PO_VENDORS; RCV_ROUTING_HEADERS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES

APPS.POFV_INBOUND_SHIPMENT_LINES is not referenced by any database object