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


VIEW: APPS.POFV_INBOUND_SHIPMENT_LINES

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

View Type

A Business Intelligence System view


This shows receiving information for items that have been shipped and/or received from a specific receipt source.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SHIPMENT_LINE_ID NUMBER
Yes
LINE_NUMBER NUMBER
Yes
RECEIVED_QUANTITY NUMBER


SHIPPED_QUANTITY NUMBER


EDI_UNIT_PRICE NUMBER


SHIPMENT_UNIT_PRICE NUMBER


ITEM_DESCRIPTION VARCHAR2 (240)

COMMENTS VARCHAR2 (4000)

SHIPMENT_LINE_STATUS VARCHAR2 (25)

_LA:ASN_LINE_FLAG CHAR (59)

BAR_CODE_LABEL VARCHAR2 (35)

CONTAINER_NUMBER VARCHAR2 (35)

_LA:DESTINATION_TYPE CHAR (77)

PACKING_SLIP_NUMBER VARCHAR2 (25)

_LA:SOURCE_DOCUMENT_TYPE CHAR (89)

SUPPLIER_ITEM_NUMBER VARCHAR2 (25)

SUPPLIER_LOT_NUMBER VARCHAR2 (30)

SUPPLIER_SHIPPED_QUANTITY NUMBER


TRANSFER_COST NUMBER


TRANSFER_PERCENTAGE NUMBER


TRUCK_NUMBER VARCHAR2 (35)

TRANSACTION_REASON_NAME VARCHAR2 (30)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
_DF CHAR (28)

SHIPMENT_ID NUMBER
Yes
SUPPLIER_ID NUMBER


SUPPLIER_NAME VARCHAR2 (240)

ITEM_ID NUMBER


_KF:ITEM_NUMBER::_CO CHAR (15)
ITEM_REVISION VARCHAR2 (3)

CATEGORY_ID NUMBER


_KF:CATEGORY::_CO CHAR (15)
OPERATING_UNIT_ID NUMBER


OPERATING_UNIT_NAME VARCHAR2 (240)

PURCHASE_ORDER_ID NUMBER


PURCHASE_ORDER_NUMBER VARCHAR2 (20)

_LA:PURCHASE_ORDER_TYPE CHAR (72)

PO_RELEASE_ID NUMBER


PO_RELEASE_NUMBER NUMBER


PO_LINE_ID NUMBER


PO_LINE_NUMBER NUMBER


PO_SHIPMENT_ID NUMBER


PO_SHIPMENT_NUMBER NUMBER


_LA:PO_SHIPMENT_TYPE CHAR (66)

PO_DISTRIBUTION_ID NUMBER


PO_DISTRIBUTION_NUMBER NUMBER


REQUISITION_LINE_ID NUMBER


REQUISITION_DOCUMENT_NUMBER VARCHAR2 (20)

REQUISITION_LINE_NUMBER NUMBER


REQ_DISTRIBUTION_ID NUMBER


REQ_DISTRIBUTION_NUMBER NUMBER


RECEIVING_ROUTING_ID NUMBER


RECEIVING_ROUTING_NAME VARCHAR2 (80)

SOURCE_ORGANIZATION_ID NUMBER


SOURCE_ORGANIZATION_CODE VARCHAR2 (3)

SOURCE_ORGANIZATION_NAME VARCHAR2 (240)

DESTINATION_ORGANIZATION_ID NUMBER


DESTINATION_ORGANIZATION_CODE VARCHAR2 (3)

DESTINATION_ORGANIZATION_NAME VARCHAR2 (240)

DESTINATION_SUBINVENTORY VARCHAR2 (10)

DELIVER_TO_LOCATION_ID NUMBER


DELIVER_TO_LOCATION VARCHAR2 (60)

DELIVER_TO_PERSON_ID NUMBER (9)

DELIVER_TO_PERSON VARCHAR2 (240)

SHIP_TO_LOCATION_ID NUMBER


SHIP_TO_LOCATION VARCHAR2 (60)

CHARGE_ACCOUNT_ID NUMBER


_KF:ACCOUNT_NUM:CHARGE:_CO CHAR (16)
TRANSPORTATION_ACCOUNT_ID NUMBER


_KF:ACCOUNT_NUM:TRANS:_CO CHAR (16)
SHIPMENT_UNIT_OF_MEASURE VARCHAR2 (25)

SHIPMENT_UOM_CLASS VARCHAR2 (10)

SHIPMENT_UOM_DESCRIPTION VARCHAR2 (50)

PRIMARY_UNIT_OF_MEASURE VARCHAR2 (25)

PRIMARY_UOM_CLASS VARCHAR2 (10)

PRIMARY_UOM_DESCRIPTION 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).
SECONDARY_QUANTITY_SHIPPED NUMBER

SECONDARY_QUANTITY_RECEIVED NUMBER

SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
QC_GRADE VARCHAR2 (150)
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.
Query Text

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


SELECT SHIPMENT_LINE_ID
,      LINE_NUMBER
,      RECEIVED_QUANTITY
,      SHIPPED_QUANTITY
,      EDI_UNIT_PRICE
,      SHIPMENT_UNIT_PRICE
,      ITEM_DESCRIPTION
,      COMMENTS
,      SHIPMENT_LINE_STATUS
,      _LA:ASN_LINE_FLAG
,      BAR_CODE_LABEL
,      CONTAINER_NUMBER
,      _LA:DESTINATION_TYPE
,      PACKING_SLIP_NUMBER
,      _LA:SOURCE_DOCUMENT_TYPE
,      SUPPLIER_ITEM_NUMBER
,      SUPPLIER_LOT_NUMBER
,      SUPPLIER_SHIPPED_QUANTITY
,      TRANSFER_COST
,      TRANSFER_PERCENTAGE
,      TRUCK_NUMBER
,      TRANSACTION_REASON_NAME
,      USSGL_TRANSACTION_CODE
,      _DF
,      SHIPMENT_ID
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      ITEM_ID
,      _KF:ITEM_NUMBER::_CO
,      ITEM_REVISION
,      CATEGORY_ID
,      _KF:CATEGORY::_CO
,      OPERATING_UNIT_ID
,      OPERATING_UNIT_NAME
,      PURCHASE_ORDER_ID
,      PURCHASE_ORDER_NUMBER
,      _LA:PURCHASE_ORDER_TYPE
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_SHIPMENT_ID
,      PO_SHIPMENT_NUMBER
,      _LA:PO_SHIPMENT_TYPE
,      PO_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUMBER
,      REQUISITION_LINE_ID
,      REQUISITION_DOCUMENT_NUMBER
,      REQUISITION_LINE_NUMBER
,      REQ_DISTRIBUTION_ID
,      REQ_DISTRIBUTION_NUMBER
,      RECEIVING_ROUTING_ID
,      RECEIVING_ROUTING_NAME
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_NAME
,      DESTINATION_ORGANIZATION_ID
,      DESTINATION_ORGANIZATION_CODE
,      DESTINATION_ORGANIZATION_NAME
,      DESTINATION_SUBINVENTORY
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_LOCATION
,      DELIVER_TO_PERSON_ID
,      DELIVER_TO_PERSON
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      CHARGE_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:CHARGE:_CO
,      TRANSPORTATION_ACCOUNT_ID
,      _KF:ACCOUNT_NUM:TRANS:_CO
,      SHIPMENT_UNIT_OF_MEASURE
,      SHIPMENT_UOM_CLASS
,      SHIPMENT_UOM_DESCRIPTION
,      PRIMARY_UNIT_OF_MEASURE
,      PRIMARY_UOM_CLASS
,      PRIMARY_UOM_DESCRIPTION
,      CREATED_DATE
,      CREATED_BY
,      LAST_UPDATED_DATE
,      LAST_UPDATED_BY
,      SECONDARY_QUANTITY_SHIPPED
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_UNIT_OF_MEASURE
,      QC_GRADE
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
FROM APPS.POFV_INBOUND_SHIPMENT_LINES;

Dependencies

[top of page]

APPS.POFV_INBOUND_SHIPMENT_LINES references the following:

SchemaAPPS
SynonymGL_CODE_COMBINATIONS
SynonymHR_ALL_ORGANIZATION_UNITS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_CATEGORIES
SynonymMTL_ITEM_REVISIONS
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_TRANSACTION_REASONS
SynonymMTL_UNITS_OF_MEASURE
ViewPER_PEOPLE_F
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymPO_REQ_DISTRIBUTIONS_ALL
ViewPO_VENDORS
ViewRCV_ROUTING_HEADERS
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES

APPS.POFV_INBOUND_SHIPMENT_LINES is not referenced by any database object