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


VIEW: APPS.INVFV_INVENTORY_SUPPLIES

Object Details
Object Name: INVFV_INVENTORY_SUPPLIES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVFV_INVENTORY_SUPPLIES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows incoming supply information for an organization.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUPPLY_TYPE_CODE VARCHAR2 (25)

SUPPLY_SOURCE_ID NUMBER


PO_HEADER_ID NUMBER


PO_NUMBER VARCHAR2 (20)

PO_RELEASE_ID NUMBER


PO_RELEASE_NUMBER NUMBER


PO_LINE_ID NUMBER


PO_LINE_NUMBER NUMBER


PO_LINE_LOCATION_ID NUMBER


PO_SHIPMENT_NUMBER NUMBER


PO_DISTRIBUTION_ID NUMBER


PO_DISTRIBUTION_NUMBER NUMBER


RCV_TRANSACTION_ID NUMBER


REQUISITION_HEADER_ID NUMBER


REQUISITION_NUMBER VARCHAR2 (20)

REQUISITION_LINE_ID NUMBER


REQUISITION_LINE_NUMBER NUMBER


RCV_SHIPMENT_HEADER_ID NUMBER


RCV_SHIPMENT_NUMBER VARCHAR2 (30)

RCV_SHIPMENT_LINE_ID NUMBER


RCV_SHIPMENT_LINE_NUMBER NUMBER


INVENTORY_ITEM_ID NUMBER


_KF:INVENTORY_ITEM_NAME CHAR (16)
REVISION VARCHAR2 (3)

QUANTITY NUMBER


UNIT_OF_MEASURE VARCHAR2 (25)

TO_ORG_PRIMARY_QUANTITY NUMBER


TO_ORG_PRIMARY_UOM VARCHAR2 (25)

RECEIPT_DATE DATE


NEED_BY_DATE DATE


EXPECTED_DELIVERY_DATE DATE


_LA:DESTINATION_TYPE CHAR (74)

INVENTORY_LOCATOR_ID NUMBER


_KF:INVENTORY_LOCATION_NAME CHAR (16)
FROM_ORGANIZATION_ID NUMBER


FROM_ORGANIZATION_CODE VARCHAR2 (3)

FROM_ORGANIZATION_NAME VARCHAR2 (240)

FROM_SUBINVENTORY_NAME VARCHAR2 (10)

TO_ORGANIZATION_ID NUMBER


TO_ORGANIZATION_CODE VARCHAR2 (3)

TO_ORGANIZATION_NAME VARCHAR2 (240)

TO_SUBINVENTORY_NAME VARCHAR2 (10)

INTRANSIT_OWNING_ORG_ID NUMBER


INTRANSIT_OWNING_ORG_CODE VARCHAR2 (3)

INTRANSIT_OWNING_ORG_NAME VARCHAR2 (240)

CREATED_BY NUMBER


CREATION_DATE DATE


LAST_UPDATED_BY NUMBER


LAST_UPDATE_DATE DATE


Query Text

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


SELECT SUPPLY_TYPE_CODE
,      SUPPLY_SOURCE_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_RELEASE_ID
,      PO_RELEASE_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      PO_LINE_LOCATION_ID
,      PO_SHIPMENT_NUMBER
,      PO_DISTRIBUTION_ID
,      PO_DISTRIBUTION_NUMBER
,      RCV_TRANSACTION_ID
,      REQUISITION_HEADER_ID
,      REQUISITION_NUMBER
,      REQUISITION_LINE_ID
,      REQUISITION_LINE_NUMBER
,      RCV_SHIPMENT_HEADER_ID
,      RCV_SHIPMENT_NUMBER
,      RCV_SHIPMENT_LINE_ID
,      RCV_SHIPMENT_LINE_NUMBER
,      INVENTORY_ITEM_ID
,      _KF:INVENTORY_ITEM_NAME
,      REVISION
,      QUANTITY
,      UNIT_OF_MEASURE
,      TO_ORG_PRIMARY_QUANTITY
,      TO_ORG_PRIMARY_UOM
,      RECEIPT_DATE
,      NEED_BY_DATE
,      EXPECTED_DELIVERY_DATE
,      _LA:DESTINATION_TYPE
,      INVENTORY_LOCATOR_ID
,      _KF:INVENTORY_LOCATION_NAME
,      FROM_ORGANIZATION_ID
,      FROM_ORGANIZATION_CODE
,      FROM_ORGANIZATION_NAME
,      FROM_SUBINVENTORY_NAME
,      TO_ORGANIZATION_ID
,      TO_ORGANIZATION_CODE
,      TO_ORGANIZATION_NAME
,      TO_SUBINVENTORY_NAME
,      INTRANSIT_OWNING_ORG_ID
,      INTRANSIT_OWNING_ORG_CODE
,      INTRANSIT_OWNING_ORG_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INVFV_INVENTORY_SUPPLIES;

Dependencies

[top of page]

APPS.INVFV_INVENTORY_SUPPLIES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_ITEM_LOCATIONS
SynonymMTL_PARAMETERS
SynonymMTL_SUPPLY
SynonymMTL_SYSTEM_ITEMS
SynonymPO_DISTRIBUTIONS_ALL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
SynonymRCV_TRANSACTIONS

APPS.INVFV_INVENTORY_SUPPLIES is not referenced by any database object