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: ViewPO.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 Mandatory 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 NUMBER

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:

SchemaAPPS
ViewFND_TERRITORIES_VL
SynonymHR_LOCATIONS_ALL_TL
SynonymHZ_LOCATIONS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPER_ALL_PEOPLE_F
PL/SQL PackagePOS_CANCEL_ASN - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_HEADERS_INTERFACE
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS_INTERFACE
APPS.POS_LINES_V is referenced by following:

SchemaAPPS
Package BodyPOS_ASN_NOTIF - show dependent code