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_INBOUND_SHIPMENTS

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SHIPMENT_ID	NUMBER		Yes
SHIPMENT_NUMBER	VARCHAR2	(30)
RECEIPT_NUMBER	VARCHAR2	(30)
EXPECTED_RECEIPT_DATE	DATE
SHIPPING_DATE	DATE
_LA:SHIPMENT_SOURCE	CHAR	(79)
ASN_TYPE	VARCHAR2	(25)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_RATE_DATE	DATE
COMMENTS	VARCHAR2	(4000)
CONTAINER_QUANTITY	NUMBER
BILL_OF_LADING_NUMBER	VARCHAR2	(25)
WAYBILL_AIRBILL_NUMBER	VARCHAR2	(20)
FREIGHT_AMOUNT	NUMBER
INVOICE_STATUS	VARCHAR2	(25)
INVOICE_AMOUNT	NUMBER
INVOICE_DATE	DATE
INVOICE_NUMBER	VARCHAR2	(50)
TAX_AMOUNT	NUMBER
TAX_NAME	VARCHAR2	(50)
EDI_TXN_CONTROL_NUMBER	VARCHAR2	(10)
EDI_TXN_CREATION_DATE	DATE
PACKING_SLIP_NUMBER	VARCHAR2	(25)
SHIPMENT_GROSS_WEIGHT	NUMBER
SHIPMENT_NET_WEIGHT	NUMBER
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
_DF	CHAR	(30)
SUPPLIER_ID	NUMBER
SUPPLIER_NAME	VARCHAR2	(240)
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_ORGANIZATION_CODE	VARCHAR2	(3)
SOURCE_ORGANIZATION_NAME	VARCHAR2	(240)
SHIP_TO_LOCATION_ID	NUMBER
SHIP_TO_LOCATION	VARCHAR2	(60)
CURRENCY_CODE	VARCHAR2	(15)
CURRENCY	VARCHAR2	(80)
CURRENCY_CONVERSION_RATE_TYPE	VARCHAR2	(30)
RATE_TYPE_NAME	VARCHAR2	(30)
RATE_TYPE_DESCRIPTION	VARCHAR2	(240)
GROSS_WEIGHT_UNIT_OF_MEASURE	VARCHAR2	(3)
GROSS_WEIGHT_UOM_CLASS	VARCHAR2	(10)
GROSS_WEIGHT_UOM_DESCRIPTION	VARCHAR2	(50)
NET_WEIGHT_UNIT_OF_MEASURE	VARCHAR2	(3)
NET_WEIGHT_UOM_CLASS	VARCHAR2	(10)
NET_WEIGHT_UOM_DESCRIPTION	VARCHAR2	(50)
CARRIER	VARCHAR2	(25)
CARRIER_DESCRIPTION	VARCHAR2	(80)
RECEIVER_ID	NUMBER	(9)
RECEIVER_EMPLOYEE_NUMBER	VARCHAR2	(30)
RECEIVER_NAME	VARCHAR2	(240)
PAYMENT_TERMS_ID	NUMBER
PAYMENT_TERMS_NAME	VARCHAR2	(50)
CREATED_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes	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).

Query Text

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


SELECT SHIPMENT_ID
,      SHIPMENT_NUMBER
,      RECEIPT_NUMBER
,      EXPECTED_RECEIPT_DATE
,      SHIPPING_DATE
,      _LA:SHIPMENT_SOURCE
,      ASN_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_RATE_DATE
,      COMMENTS
,      CONTAINER_QUANTITY
,      BILL_OF_LADING_NUMBER
,      WAYBILL_AIRBILL_NUMBER
,      FREIGHT_AMOUNT
,      INVOICE_STATUS
,      INVOICE_AMOUNT
,      INVOICE_DATE
,      INVOICE_NUMBER
,      TAX_AMOUNT
,      TAX_NAME
,      EDI_TXN_CONTROL_NUMBER
,      EDI_TXN_CREATION_DATE
,      PACKING_SLIP_NUMBER
,      SHIPMENT_GROSS_WEIGHT
,      SHIPMENT_NET_WEIGHT
,      USSGL_TRANSACTION_CODE
,      _DF
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_NAME
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      CURRENCY_CODE
,      CURRENCY
,      CURRENCY_CONVERSION_RATE_TYPE
,      RATE_TYPE_NAME
,      RATE_TYPE_DESCRIPTION
,      GROSS_WEIGHT_UNIT_OF_MEASURE
,      GROSS_WEIGHT_UOM_CLASS
,      GROSS_WEIGHT_UOM_DESCRIPTION
,      NET_WEIGHT_UNIT_OF_MEASURE
,      NET_WEIGHT_UOM_CLASS
,      NET_WEIGHT_UOM_DESCRIPTION
,      CARRIER
,      CARRIER_DESCRIPTION
,      RECEIVER_ID
,      RECEIVER_EMPLOYEE_NUMBER
,      RECEIVER_NAME
,      PAYMENT_TERMS_ID
,      PAYMENT_TERMS_NAME
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.POFV_INBOUND_SHIPMENTS;

Dependencies

[top of page]

APPS.POFV_INBOUND_SHIPMENTS references the following:

APPS: AP_TERMS; FND_CURRENCIES_VL; GL_DAILY_CONVERSION_TYPES; HR_ALL_ORGANIZATION_UNITS; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; MTL_PARAMETERS; MTL_UNITS_OF_MEASURE; ORG_FREIGHT; PER_PEOPLE_F; PO_VENDORS; RCV_SHIPMENT_HEADERS

APPS.POFV_INBOUND_SHIPMENTS is not referenced by any database object