[Home] [Help] [Dependency Information]
Object Name: | CST_INTRANSIT_VALUE_VIEW |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_INTRANSIT_VALUE_VIEW |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|