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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

POS_LINES_V is the view used to select the line-level info for the Advance Shipment Notice

[View Source]

Columns

Name	Datatype	Length	Comments
PACKING_SLIP	VARCHAR2	(25)	Packing Slip
COMMENTS	VARCHAR2	(4000)	Comments
CONTAINER_NUM	VARCHAR2	(35)	Container Number
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	(2)	Country of Origin Code
BARCODE_LABEL	VARCHAR2	(35)	Barcode Label
TRUCK_NUM	VARCHAR2	(35)	Truck Number
DOCUMENT_LINE_NUM	VARCHAR2	(50)	Document Line Number
DOCUMENT_SHIPMENT_LINE_NUM	NUMBER		Document Shipment Line Number
ITEM_DESCRIPTION	VARCHAR2	(240)	Item Description
VENDOR_LOT_NUM	VARCHAR2	(30)	Vendor Lot Number
USE_MTL_SERIAL	NUMBER		USE MTL SERIAL
VENDOR_CUM_SHIPPED_QTY	NUMBER		Vendor Cumulative Shipped Quantity
DELIVER_TO_LOCATION_CODE	VARCHAR2	(60)	Deliver To Location Code
DELIVER_TO_PERSON_NAME	VARCHAR2	(240)	Deliver To Person Name
DESTINATION_TYPE_CODE	VARCHAR2	(25)	Destination Type Code
LOCATOR	VARCHAR2	(81)	Locator
NUM_OF_CONTAINERS	NUMBER		Number of Containers
PO_REVISION_NUM	NUMBER		PO Revision Number
RMA_REFERENCE	VARCHAR2	(30)	RMA Reference
SUBINVENTORY	VARCHAR2	(10)	Sub-inventory
TRANSFER_COST	NUMBER		Transfer Cost
ACTUAL_COST	NUMBER		Actual Cost
TRANSPORTATION_ACCOUNT_ID	NUMBER		Transportation Account Identifier
TRANSPORTATION_COST	NUMBER		Transportation Cost
PO_HEADER_ID	NUMBER		PO Header Identifier
PO_LINE_ID	NUMBER		PO Line Identifier
PO_LINE_LOCATION_ID	NUMBER		PO Line Location Identifier
QUANTITY	NUMBER		Quantity Shipped
UNIT_OF_MEASURE	VARCHAR2	(25)	Unit Of Measure
UOM_CODE	VARCHAR2	(3)	Unit Of Measure
ITEM_ID	NUMBER		Item Identifier
SHIP_TO_LOCATION_CODE	VARCHAR2	(60)	Ship To Location Code
TO_ORGANIZATION_ID	NUMBER		To Organization Identifier
PO_UNIT_PRICE	NUMBER		PO Unit Price
VENDOR_ID	NUMBER		Vendor Identifier
VENDOR_ITEM_NUM	VARCHAR2	(25)	Supplier Item Number
VENDOR_SITE_CODE	VARCHAR2	(15)	Supplier Site Code
VENDOR_SITE_ID	NUMBER		Suplier Site Identifier
ATTRIBUTE15	VARCHAR2	(150)	flexfield 15
VENDOR_NAME	VARCHAR2	(240)	Supplier Name
SHIPMENT_NUM	VARCHAR2	(30)	Shipment Number
LINE_SEQUENCE	CHAR	(0)	Line Sequence
PO_NUMBER	VARCHAR2	(61)	PO Number
ITEM_NUMBER	VARCHAR2	(40)	Item Number
QUANTITY_INVOICED	CHAR	(0)	Quantity Invoiced
TAXABLE_FLAG	CHAR	(0)	Taxable Flag
TAX_NAME	VARCHAR2	(50)	Tax Name
TAX_AMOUNT	NUMBER		Tax Amount
CURRENCY_CODE	VARCHAR2	(15)	Currency Code
CONVERSION_RATE	NUMBER		Conversion rate
CONVERSION_DATE	DATE		Conversion Date
LINE_IDENTIFIER	CHAR	(0)	Line Identifier
COUNTRY_OF_ORIGIN_DISPLAYED	VARCHAR2	(80)	Country of Origin Name
DUE_DATE	DATE		Due Date
QUANTITY_ORDERED	NUMBER		Quantity Ordered
QUANTITY_RECEIVED	NUMBER		Quantity Received
HEADER_INTERFACE_ID	NUMBER		Shipment Header Identifier
PROCESSING_STATUS_CODE	VARCHAR2	(25)	Processing Status Code
TRANSACTION_STATUS_CODE	VARCHAR2	(25)	Transaction Status Code
CANCELLATION_STATUS	VARCHAR2	(4000)	Cancellation Status
OPERATING_UNIT_ID	NUMBER		Operating Unit Identifier
PO_RELEASE_ID	NUMBER		PO Release Identifier
BUYER_ID	NUMBER		Buyer ID

Query Text

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


SELECT PACKING_SLIP
,      COMMENTS
,      CONTAINER_NUM
,      COUNTRY_OF_ORIGIN_CODE
,      BARCODE_LABEL
,      TRUCK_NUM
,      DOCUMENT_LINE_NUM
,      DOCUMENT_SHIPMENT_LINE_NUM
,      ITEM_DESCRIPTION
,      VENDOR_LOT_NUM
,      USE_MTL_SERIAL
,      VENDOR_CUM_SHIPPED_QTY
,      DELIVER_TO_LOCATION_CODE
,      DELIVER_TO_PERSON_NAME
,      DESTINATION_TYPE_CODE
,      LOCATOR
,      NUM_OF_CONTAINERS
,      PO_REVISION_NUM
,      RMA_REFERENCE
,      SUBINVENTORY
,      TRANSFER_COST
,      ACTUAL_COST
,      TRANSPORTATION_ACCOUNT_ID
,      TRANSPORTATION_COST
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      QUANTITY
,      UNIT_OF_MEASURE
,      UOM_CODE
,      ITEM_ID
,      SHIP_TO_LOCATION_CODE
,      TO_ORGANIZATION_ID
,      PO_UNIT_PRICE
,      VENDOR_ID
,      VENDOR_ITEM_NUM
,      VENDOR_SITE_CODE
,      VENDOR_SITE_ID
,      ATTRIBUTE15
,      VENDOR_NAME
,      SHIPMENT_NUM
,      LINE_SEQUENCE
,      PO_NUMBER
,      ITEM_NUMBER
,      QUANTITY_INVOICED
,      TAXABLE_FLAG
,      TAX_NAME
,      TAX_AMOUNT
,      CURRENCY_CODE
,      CONVERSION_RATE
,      CONVERSION_DATE
,      LINE_IDENTIFIER
,      COUNTRY_OF_ORIGIN_DISPLAYED
,      DUE_DATE
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      HEADER_INTERFACE_ID
,      PROCESSING_STATUS_CODE
,      TRANSACTION_STATUS_CODE
,      CANCELLATION_STATUS
,      OPERATING_UNIT_ID
,      PO_RELEASE_ID
,      BUYER_ID
FROM APPS.POS_LINES_V;

Dependencies

[top of page]

APPS.POS_LINES_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_TERRITORIES_VL; HR_LOCATIONS_ALL_TL; HZ_LOCATIONS; MTL_SYSTEM_ITEMS_KFV; PER_ALL_PEOPLE_F; POS_CANCEL_ASN - show dependent code; PO_HEADERS_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_HEADERS_INTERFACE; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS_INTERFACE

APPS.POS_LINES_V is referenced by following:

APPS: POS_ASN_NOTIF - show dependent code