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

VIEW: APPS.CST_INTRANSIT_VALUE_VIEW

Object Details
Object Name: CST_INTRANSIT_VALUE_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.CST_INTRANSIT_VALUE_VIEW
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTRANSIT_OWNING_ORG_ID NUMBER

Owner organization identifier
COST_GROUP_ID NUMBER

FROM_ORGANIZATION_ID NUMBER

Sending organizaiton identifier
FROM_SUBINVENTORY VARCHAR2 (10)
Sending subinventory
TO_ORGANIZATION_ID NUMBER

Destination organization identifier
TO_SUBINVENTORY VARCHAR2 (10)
Destination subinventory
SUPPLY_TYPE_CODE VARCHAR2 (25) Yes Supply Type Code from MTL_SUPPLY
FOB_POINT NUMBER

Freight on board point
SHIPMENT_NUM VARCHAR2 (30)
Shipment number
RECEIPT_NUM VARCHAR2 (30)
Receipt number
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight carrier code
WAYBILL_AIRBILL_NUM VARCHAR2 (30)
Waybill / airbill number
NUM_OF_CONTAINERS NUMBER

Number of containers
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
REVISION VARCHAR2 (3)
Inventory item revision
QUANTITY NUMBER
Yes Actual shipment quantity
UNIT_OF_MEASURE VARCHAR2 (25) Yes Unit of measure for actual shipment quantity
UOM_CODE VARCHAR2 (3) Yes Unit of measure code for actual shipment quantity
TO_ORG_PRIMARY_QUANTITY NUMBER

Shipment quantity in primary unit of measure of item in destination organization
TO_ORG_PRIMARY_UOM VARCHAR2 (25)
Primary unit of measure of item in destination organization
TO_ORG_PRIMARY_UOM_CODE VARCHAR2 (3) Yes Primary unit of measure of item in destination organization
RECEIPT_DATE DATE

Receipt date
NEED_BY_DATE DATE

Need by date
EXPECTED_DELIVERY_DATE DATE

Expected delivery date
SHIPPED_DATE DATE

Shipped date
DESTINATION_TYPE_CODE VARCHAR2 (25) Yes Destination type
SHIPMENT_LINE_STATUS_CODE VARCHAR2 (25)
Shipment line status
SOURCE_DOCUMENT_CODE VARCHAR2 (25)
Shipment source document type
DELIVER_TO_LOCATION_ID NUMBER

Deliver to location identifier
CHARGE_ACCOUNT_ID NUMBER

Charge account identifier
TRANSPORTATION_ACCOUNT_ID NUMBER

Transportation account identifier
SHIPMENT_UNIT_PRICE NUMBER

Shipment unit price
TRANSFER_COST NUMBER

Transfer cost
TRANSPORTATION_COST NUMBER

Transportation cost
SHIPMENT_LINE_ID NUMBER
Yes
Query Text

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


SELECT INTRANSIT_OWNING_ORG_ID
,      COST_GROUP_ID
,      FROM_ORGANIZATION_ID
,      FROM_SUBINVENTORY
,      TO_ORGANIZATION_ID
,      TO_SUBINVENTORY
,      SUPPLY_TYPE_CODE
,      FOB_POINT
,      SHIPMENT_NUM
,      RECEIPT_NUM
,      FREIGHT_CARRIER_CODE
,      WAYBILL_AIRBILL_NUM
,      NUM_OF_CONTAINERS
,      INVENTORY_ITEM_ID
,      REVISION
,      QUANTITY
,      UNIT_OF_MEASURE
,      UOM_CODE
,      TO_ORG_PRIMARY_QUANTITY
,      TO_ORG_PRIMARY_UOM
,      TO_ORG_PRIMARY_UOM_CODE
,      RECEIPT_DATE
,      NEED_BY_DATE
,      EXPECTED_DELIVERY_DATE
,      SHIPPED_DATE
,      DESTINATION_TYPE_CODE
,      SHIPMENT_LINE_STATUS_CODE
,      SOURCE_DOCUMENT_CODE
,      DELIVER_TO_LOCATION_ID
,      CHARGE_ACCOUNT_ID
,      TRANSPORTATION_ACCOUNT_ID
,      SHIPMENT_UNIT_PRICE
,      TRANSFER_COST
,      TRANSPORTATION_COST
,      SHIPMENT_LINE_ID
FROM APPS.CST_INTRANSIT_VALUE_VIEW;

Dependencies

[top of page]

APPS.CST_INTRANSIT_VALUE_VIEW references the following:

SchemaAPPS
SynonymMTL_INTERORG_PARAMETERS
SynonymMTL_PARAMETERS
SynonymMTL_SUPPLY
SynonymMTL_UNITS_OF_MEASURE
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES
APPS.CST_INTRANSIT_VALUE_VIEW is referenced by following:

SchemaAPPS
ViewINV_BIS_SUPPLY_CHAIN_INVENTORY
Package BodyINV_TURNS - show dependent code
ViewMTL_BIS_INV_VALUE_V