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_STD_PO_LINE_SHIPMENTS

Object Details

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

View Type

A Business Intelligence System view

This shows scheduling information for a standard purchase order line. Scheduling information includes information such as quantity and ship-to location.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_SHIPMENT_ID	NUMBER		Yes
SHIPMENT_NUMBER	NUMBER
PO_LINE_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
STANDARD_PO_ID	NUMBER		Yes
STANDARD_PO_DOCUMENT_NUMBER	VARCHAR2	(20)	Yes
OPERATING_UNIT_ID	NUMBER
OPERATING_UNIT_NAME	VARCHAR2	(240)	Yes
ACTUAL_PRICE	NUMBER
NEED_BY_DATE	DATE
PROMISED_DATE	DATE
LATEST_ACCEPTABLE_DATE	DATE
ORDERED_QUANTITY	NUMBER
SHIPPED_QUANTITY	NUMBER
RECEIVED_QUANTITY	NUMBER
CANCELLED_QUANTITY	NUMBER
ACCEPTED_QUANTITY	NUMBER
REJECTED_QUANTITY	NUMBER
BILLED_QUANTITY	NUMBER
_LA:APPROVED_FLAG	CHAR	(59)
APPROVAL_DATE	DATE
_LA:CANCEL_FLAG	CHAR	(57)
CANCEL_DATE	DATE
CANCEL_REASON	VARCHAR2	(240)
_LA:CLOSURE_STATUS	CHAR	(65)
CLOSED_DATE	DATE
CLOSED_REASON	VARCHAR2	(240)
_LA:FIRM_STATUS	CHAR	(69)
_LA:ENCUMBERED_FLAG	CHAR	(61)
ENCUMBERED_DATE	DATE
_LA:ACCRUE_ON_RECEIPT_FLAG	CHAR	(68)
_LA:ALLOW_SUBSTITUTE_RECEIPT	CHAR	(76)
_LA:ENFORCE_SHIP_TO_LOCATION	CHAR	(92)
_LA:INVOICE_MATCHING	CHAR	(185)
QUANTITY_RECEIVED_TOLERANCE	NUMBER
_LA:QTY_RECEIVED_EXCEPTION	CHAR	(85)
EARLY_RECEIPT_ALLOWED_DAYS	NUMBER
LATE_RECEIPT_ALLOWED_DAYS	NUMBER
_LA:RECEIPT_DAYS_EXCEPTION	CHAR	(90)
RECEIVING_CLOSE_TOLERANCE	NUMBER
INVOICE_CLOSE_TOLERANCE	NUMBER
_LA:TAXABLE_FLAG	CHAR	(58)
TAX_NAME	VARCHAR2	(0)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
_DF	CHAR	(27)
UNIT_OF_MEASURE	VARCHAR2	(25)
UOM_CLASS	VARCHAR2	(10)
UOM_DESCRIPTION	VARCHAR2	(50)
SHIP_TO_ORGANIZATION_ID	NUMBER
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)
SHIP_TO_ORGANIZATION_NAME	VARCHAR2	(240)
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_LOCATION	VARCHAR2	(60)
RECEIVING_ROUTING_ID	NUMBER
RECEIVING_ROUTING_NAME	VARCHAR2	(80)
CREATED_DATE	DATE
CREATED_BY	NUMBER			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	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
PREFERRED_GRADE	VARCHAR2	(150)
RETROACTIVE_DATE	DATE
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.
_LA:VMI_FLAG	CHAR	(54)
_LA:CONSIGNED_FLAG	CHAR	(60)
AMOUNT	NUMBER			Stores the amount on the shipments for service lines
AMOUNT_CANCELLED	NUMBER			Amount cancelled for service lines
AMOUNT_RECEIVED	NUMBER			Stores the amount received for service lines
AMOUNT_BILLED	NUMBER			Stores the amount billed for service lines
AMOUNT_ACCEPTED	NUMBER			Amount accepted for service lines
AMOUNT_REJECTED	NUMBER			Amount rejected for service lines
FINAL_MATCH_FLAG	VARCHAR2	(1)		This flag indicates if the shipment is finally matched by AP invoice.
SHIPMENT_CLOSED_DATE	DATE
CLOSED_FOR_RECEIVING_DATE	DATE
CLOSED_FOR_INVOICE_DATE	DATE

Query Text

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


SELECT PO_SHIPMENT_ID
,      SHIPMENT_NUMBER
,      PO_LINE_ID
,      LINE_NUMBER
,      STANDARD_PO_ID
,      STANDARD_PO_DOCUMENT_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      ACTUAL_PRICE
,      NEED_BY_DATE
,      PROMISED_DATE
,      LATEST_ACCEPTABLE_DATE
,      ORDERED_QUANTITY
,      SHIPPED_QUANTITY
,      RECEIVED_QUANTITY
,      CANCELLED_QUANTITY
,      ACCEPTED_QUANTITY
,      REJECTED_QUANTITY
,      BILLED_QUANTITY
,      _LA:APPROVED_FLAG
,      APPROVAL_DATE
,      _LA:CANCEL_FLAG
,      CANCEL_DATE
,      CANCEL_REASON
,      _LA:CLOSURE_STATUS
,      CLOSED_DATE
,      CLOSED_REASON
,      _LA:FIRM_STATUS
,      _LA:ENCUMBERED_FLAG
,      ENCUMBERED_DATE
,      _LA:ACCRUE_ON_RECEIPT_FLAG
,      _LA:ALLOW_SUBSTITUTE_RECEIPT
,      _LA:ENFORCE_SHIP_TO_LOCATION
,      _LA:INVOICE_MATCHING
,      QUANTITY_RECEIVED_TOLERANCE
,      _LA:QTY_RECEIVED_EXCEPTION
,      EARLY_RECEIPT_ALLOWED_DAYS
,      LATE_RECEIPT_ALLOWED_DAYS
,      _LA:RECEIPT_DAYS_EXCEPTION
,      RECEIVING_CLOSE_TOLERANCE
,      INVOICE_CLOSE_TOLERANCE
,      _LA:TAXABLE_FLAG
,      TAX_NAME
,      USSGL_TRANSACTION_CODE
,      _DF
,      UNIT_OF_MEASURE
,      UOM_CLASS
,      UOM_DESCRIPTION
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      SHIP_TO_ORGANIZATION_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      PREFERRED_GRADE
,      RETROACTIVE_DATE
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
,      _LA:VMI_FLAG
,      _LA:CONSIGNED_FLAG
,      AMOUNT
,      AMOUNT_CANCELLED
,      AMOUNT_RECEIVED
,      AMOUNT_BILLED
,      AMOUNT_ACCEPTED
,      AMOUNT_REJECTED
,      FINAL_MATCH_FLAG
,      SHIPMENT_CLOSED_DATE
,      CLOSED_FOR_RECEIVING_DATE
,      CLOSED_FOR_INVOICE_DATE
FROM APPS.POFV_STD_PO_LINE_SHIPMENTS;

Dependencies

[top of page]

APPS.POFV_STD_PO_LINE_SHIPMENTS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS; MTL_PARAMETERS; MTL_UNITS_OF_MEASURE; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; RCV_ROUTING_HEADERS

APPS.POFV_STD_PO_LINE_SHIPMENTS is not referenced by any database object