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

Object Details

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

View Type

A Business Intelligence System view

This shows scheduling information for a 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
VALUE_BASIS	NUMBER		Yes	Value Basis
PO_LINE_ID	NUMBER		Yes
LINE_NUMBER	NUMBER		Yes
PURCHASE_ORDER_ID	VARCHAR2	(20)	Yes
PO_DOCUMENT_NUMBER	NUMBER
RELEASE_ID	NUMBER
RELEASE_NUMBER	NUMBER
OPERATING_UNIT_ID	VARCHAR2	(240)	Yes
OPERATING_UNIT_NAME	CHAR	(66)
_LA:SHIPMENT_TYPE	NUMBER
ACTUAL_PRICE	DATE
NEED_BY_DATE	DATE
PROMISED_DATE	DATE
LATEST_ACCEPTABLE_DATE	NUMBER
ORDERED_QUANTITY	NUMBER
SHIPPED_QUANTITY	NUMBER
RECEIVED_QUANTITY	NUMBER
CANCELLED_QUANTITY	NUMBER
ACCEPTED_QUANTITY	NUMBER
REJECTED_QUANTITY	NUMBER
BILLED_QUANTITY	CHAR	(59)
_LA:APPROVED_FLAG	DATE
APPROVAL_DATE	CHAR	(57)
_LA:CANCEL_FLAG	DATE
CANCEL_DATE	VARCHAR2	(240)
CANCEL_REASON	CHAR	(65)
_LA:CLOSURE_STATUS	DATE
CLOSED_DATE	VARCHAR2	(240)
CLOSED_REASON	CHAR	(69)
_LA:FIRM_STATUS	CHAR	(61)
_LA:ENCUMBERED_FLAG	DATE
ENCUMBERED_DATE	CHAR	(68)
_LA:ACCRUE_ON_RECEIPT_FLAG	CHAR	(76)
_LA:ALLOW_SUBSTITUTE_RECEIPT	CHAR	(92)
_LA:ENFORCE_SHIP_TO_LOCATION	CHAR	(185)
_LA:INVOICE_MATCHING	NUMBER
QUANTITY_RECEIVED_TOLERANCE	CHAR	(85)
_LA:QTY_RECEIVED_EXCEPTION	NUMBER
EARLY_RECEIPT_ALLOWED_DAYS	NUMBER
LATE_RECEIPT_ALLOWED_DAYS	CHAR	(90)
_LA:RECEIPT_DAYS_EXCEPTION	NUMBER
RECEIVING_CLOSE_TOLERANCE	NUMBER
INVOICE_CLOSE_TOLERANCE	CHAR	(58)
_LA:TAXABLE_FLAG	VARCHAR2	(30)
TAX_NAME	VARCHAR2	(30)
USSGL_TRANSACTION_CODE	VARCHAR2	(25)
UNIT_OF_MEASURE	NUMBER
SHIP_TO_ORGANIZATION_ID	NUMBER
SHIP_TO_LOCATION_ID	NUMBER
RECEIVING_ROUTING_ID	DATE
CREATED_DATE	NUMBER
CREATED_BY	DATE		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_DATE	NUMBER		Yes
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SECONDARY_QUANTITY	VARCHAR2	(25)
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(150)
PREFERRED_GRADE	DATE
RETROACTIVE_DATE	VARCHAR2	(1)
DROP_SHIP_FLAG	DATE			Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE	CHAR	(54)		The date/time when any of referenced data elements on the backing Sales Order Line is updated.
_LA:VMI_FLAG	CHAR	(60)
_LA:CONSIGNED_FLAG	NUMBER
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	VARCHAR2	(1)		Amount rejected for service lines
MANUAL_PRICE_CHANGE_FLAG	VARCHAR2	(1)		Only for Blanket Release shipments: Y if the user has manually entered a price overriding the Blanket Agreement price, N or null otherwise.
FINAL_MATCH_FLAG	DATE			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	VARCHAR2	(25)
MATCHING_BASIS	VARCHAR2	(30)		Matching Basis
PAYMENT_TYPE	VARCHAR2	(30)		Payment Type
DESCRIPTION	VARCHAR2	(240)		Description
WORK_APPROVER_ID	NUMBER			Work Approver Id
BID_PAYMENT_ID	NUMBER			Bid Payment Id
QUANTITY_FINANCED	NUMBER			Quantity Financed
AMOUNT_FINANCED	NUMBER			Amount Financed
QUANTITY_RECOUPED	NUMBER			Quantity Recouped
AMOUNT_RECOUPED	NUMBER			Amount Recouped
RETAINAGE_WITHHELD_AMOUNT	NUMBER			Retainage Withheld Amount
RETAINAGE_RELEASED_AMOUNT	NUMBER			Retainage Released Amount
OUTSOURCED_ASSEMBLY	NUMBER		Yes	Outsourced Assembly
ORIGINAL_SHIPMENT_ID	VARCHAR2	(15)		Original Shipment Id
TAX_ATTRIBUTE_UPDATE_CODE	NUMBER			Tax Attribute Update Code

Query Text

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


SELECT PO_SHIPMENT_ID
,      SHIPMENT_NUMBER
,      VALUE_BASIS
,      PO_LINE_ID
,      LINE_NUMBER
,      PURCHASE_ORDER_ID
,      PO_DOCUMENT_NUMBER
,      RELEASE_ID
,      RELEASE_NUMBER
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      _LA:SHIPMENT_TYPE
,      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
,      UNIT_OF_MEASURE
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_LOCATION_ID
,      RECEIVING_ROUTING_ID
,      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
,      MANUAL_PRICE_CHANGE_FLAG
,      FINAL_MATCH_FLAG
,      SHIPMENT_CLOSED_DATE
,      CLOSED_FOR_RECEIVING_DATE
,      CLOSED_FOR_INVOICE_DATE
,      MATCHING_BASIS
,      PAYMENT_TYPE
,      DESCRIPTION
,      WORK_APPROVER_ID
,      BID_PAYMENT_ID
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      OUTSOURCED_ASSEMBLY
,      ORIGINAL_SHIPMENT_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
FROM APPS.POBV_PO_LINE_SHIPMENTS;

Dependencies

[top of page]

APPS.POBV_PO_LINE_SHIPMENTS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL

APPS.POBV_PO_LINE_SHIPMENTS is not referenced by any database object