DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.POBV_INBOUND_SHIPMENTS

Object Details
Object Name: POBV_INBOUND_SHIPMENTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POBV_INBOUND_SHIPMENTS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows receiving information for the source of actual or expected receipts. The receipts can be grouped by the source type (Internal or Supplier) and the source of the receipt.


[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)

SUPPLIER_ID NUMBER


SOURCE_ORGANIZATION_ID NUMBER


SHIP_TO_LOCATION_ID NUMBER


CURRENCY_CODE VARCHAR2 (15)

CURRENCY_CONVERSION_RATE_TYPE VARCHAR2 (30)

GROSS_WEIGHT_UNIT_OF_MEASURE VARCHAR2 (3)

NET_WEIGHT_UNIT_OF_MEASURE VARCHAR2 (3)

CARRIER VARCHAR2 (25)

RECEIVER_ID NUMBER (9)

PAYMENT_TERMS_ID NUMBER


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
,      SUPPLIER_ID
,      SOURCE_ORGANIZATION_ID
,      SHIP_TO_LOCATION_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_RATE_TYPE
,      GROSS_WEIGHT_UNIT_OF_MEASURE
,      NET_WEIGHT_UNIT_OF_MEASURE
,      CARRIER
,      RECEIVER_ID
,      PAYMENT_TERMS_ID
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
FROM APPS.POBV_INBOUND_SHIPMENTS;

Dependencies

[top of page]

APPS.POBV_INBOUND_SHIPMENTS references the following:

SchemaAPPS
SynonymRCV_SHIPMENT_HEADERS

APPS.POBV_INBOUND_SHIPMENTS is not referenced by any database object