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

Object Details

Object Name:	AP_PO_SHIPMENTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	SQLAP.AP_PO_SHIPMENTS_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

This view shows an Internet Supplier Portal user PO shipment information that he uses to enter invoices. This view is used to display information on the Create Invoice:Select Purchase Orders page.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_NUMBER_DISPLAY	VARCHAR2	(102)		Purchase order document display information. If po_release_number exists then display po_number-po_release_number, else display po_number-po_line_number-po_shipment_number.
PO_NUMBER	VARCHAR2	(20)	Yes	Purchase order document number (PO_HEADERS_ALL.SEGMENT1)
PO_HEADER_ID	NUMBER		Yes	Purchase order document header unique identifier (PO_HEADERS_ALL.PO_HEADER_ID)
AGENT_ID	NUMBER	(9)	Yes	Unique identifier for purchase order buyer (PO_HEADERS_ALL.AGENT_ID)
CREATION_DATE	DATE			Standard who column - date when this row was created.
VENDOR_ID	NUMBER			Supplier unique identifier for purchase order (PO_HEADERS_ALL.VENDOR_CONTACT_ID)
VENDOR_SITE_ID	NUMBER			Purchase order supplier site unique identifier (PO_HEADERS_ALL.VENDOR_SITE_ID)
VENDOR_CONTACT_ID	NUMBER			Purchase order supplier contact unique identifier (PO_HEADERS_ALL.VENDOR_CONTACT_ID)
LINE_NUM	NUMBER		Yes	Purchase order document line number (PO_LINES_ALL.LINE_NUM)
VENDOR_NAME	VARCHAR2	(240)		Supplier name for purchase order (PO_VENDORS.VENDOR_NAME)
VENDOR_NUM	VARCHAR2	(30)	Yes	Supplier number for purchase order (PO_VENDORS.SEGMENT1)
ITEM_ID	NUMBER			Item unique identifier for purchase order (PO_LINES_ALL.ITEM_ID)
ITEM_DESCRIPTION	VARCHAR2	(240)		Purchase order item description (PO_LINES_ALL.ITEM_DESCRIPTION)
UNIT_PRICE	NUMBER			Purchase order item unit price (PO_LINES_ALL.UNIT_PRICE)
DUE_DATE	DATE			Due date for purchase order. Use PO_LINE_LOCATIONS_ALL.PROMISED_DATE if it exists, else use PO_LINE_LOCATIONS_ALL.NEED_BY_DATE
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of measure lookup code for item (PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE)
UOM_CLASS	VARCHAR2	(10)		Unit of measure class for item (MTL_UNITS_OF_MEASURE.UOM_CLASS)
QUANTITY_ORDERED	NUMBER			Quantity ordered for item (PO_LINE_LOCATIONS_ALL.QUANTITY)
QUANTITY_RECEIVED	NUMBER			Quantity received for item (PO_LINE_LOCATIONS_ALL.QUANTITY_RECEIVED)
QUANTITY_BILLED	NUMBER			Quantity billed for item (PO_LINE_LOCATIONS_ALL.QUANTITY_BILLED)
SHIP_TO_LOCATION	VARCHAR2	(60)		Shipment destination code for item (HR_LOCATIONS_ALL.LOCATION_CODE)
VENDOR_SITE_CODE	VARCHAR2	(15)	Yes	Supplier site code (PO_VENDOR_SITES_ALL.VENDOR_SITE_CODE)
PAY_SITE_FLAG	VARCHAR2	(1)		Supplier site is pay site flag (PO_VENDOR_SITES_ALL.PAY_SITE_FLAG)
CURRENCY_CODE	VARCHAR2	(15)		Purchase order currency code (PO_HEADERS_ALL.CURRENCY_CODE)
PO_LINE_ID	NUMBER		Yes	Purchase order document line unique identifier (PO_LINES_ALL.PO_LINE_ID)
LINE_LOCATION_ID	NUMBER		Yes	Purchase order document line location unique identifier (PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID)
SHIPTO_ORG_ID	NUMBER			Shipment destination organization unique identifier (PO_LINE_LOCATIONS_ALL.SHIP_TO_ORGANIZATION_ID)
SHIPMENT_NUM	NUMBER			Shipment number for item (PO_LINE_LOCATIONS_ALL.SHIPMENT_NUM)
TAXABLE_FLAG	VARCHAR2	(1)		Purchase order document line is taxable flag (PO_LINE_LOCATIONS_ALL.TAXABLE_FLAG)
TAX_NAME	VARCHAR2	(30)		Purchase order document line tax name (PO_LINE_LOCATIONS_ALL.TAX_NAME)
TAX_CODE_ID	NUMBER			Purchase order document line tax code unique identifier (PO_LINE_LOCATIONS_ALL.TAX_CODE_ID)
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Purchasing organization name (HR_ALL_ORGANIZATION_UNITS_TL.NAME ORGANIZATION_NAME)
ORG_ID	NUMBER			Organization identifier
PO_RELEASE_ID	NUMBER			Purchase order document release unique identifier (PO_LINE_LOCATIONS_ALL.PO_RELEASE_ID)
ITEM_NUMBER	VARCHAR2	(40)		Purchase order document line item number (MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS)
SUPPLIER_ITEM_NUMBER	VARCHAR2	(25)		Supplier item number (PO_LINES_ALL.VENDOR_PRODUCT_NUM)

Query Text

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


SELECT PO_NUMBER_DISPLAY
,      PO_NUMBER
,      PO_HEADER_ID
,      AGENT_ID
,      CREATION_DATE
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      LINE_NUM
,      VENDOR_NAME
,      VENDOR_NUM
,      ITEM_ID
,      ITEM_DESCRIPTION
,      UNIT_PRICE
,      DUE_DATE
,      UNIT_MEAS_LOOKUP_CODE
,      UOM_CLASS
,      QUANTITY_ORDERED
,      QUANTITY_RECEIVED
,      QUANTITY_BILLED
,      SHIP_TO_LOCATION
,      VENDOR_SITE_CODE
,      PAY_SITE_FLAG
,      CURRENCY_CODE
,      PO_LINE_ID
,      LINE_LOCATION_ID
,      SHIPTO_ORG_ID
,      SHIPMENT_NUM
,      TAXABLE_FLAG
,      TAX_NAME
,      TAX_CODE_ID
,      ORGANIZATION_NAME
,      ORG_ID
,      PO_RELEASE_ID
,      ITEM_NUMBER
,      SUPPLIER_ITEM_NUMBER
FROM APPS.AP_PO_SHIPMENTS_V;

Dependencies

[top of page]

APPS.AP_PO_SHIPMENTS_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL; MTL_SYSTEM_ITEMS_KFV; MTL_UNITS_OF_MEASURE; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.AP_PO_SHIPMENTS_V is not referenced by any database object