[Home] [Help] [Dependency Information]
Object Name: | CST_PAC_INTERORG_TXNS_TMP# |
---|---|
Object Type: | VIEW |
Owner: | BOM |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | ||
COST_GROUP_ID | NUMBER | Yes | ||
PAC_PERIOD_ID | NUMBER | Yes | ||
TXN_TYPE | NUMBER | Yes | ||
TRANSACTION_ACTION_ID | NUMBER | Yes | ||
TRANSACTION_SOURCE_TYPE_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
PRIMARY_QUANTITY | NUMBER | Yes | ||
PERIODIC_PRIMARY_QUANTITY | NUMBER | |||
ORGANIZATION_ID | NUMBER | Yes | ||
TRANSFER_ORGANIZATION_ID | NUMBER | |||
SUBINVENTORY_CODE | VARCHAR2 | (10) | ||
TRANSFER_PRICE | NUMBER | |||
SHIPMENT_NUMBER | VARCHAR2 | (30) | ||
TRANSFER_TRANSACTION_ID | NUMBER | |||
WAYBILL_AIRBILL | VARCHAR2 | (20) | ||
TRANSFER_COST | NUMBER | |||
TRANSPORTATION_COST | NUMBER | |||
TRANSFER_PERCENTAGE | NUMBER | |||
TRANSFER_COST_GROUP_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, COST_GROUP_ID
, PAC_PERIOD_ID
, TXN_TYPE
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID
, INVENTORY_ITEM_ID
, PRIMARY_QUANTITY
, PERIODIC_PRIMARY_QUANTITY
, ORGANIZATION_ID
, TRANSFER_ORGANIZATION_ID
, SUBINVENTORY_CODE
, TRANSFER_PRICE
, SHIPMENT_NUMBER
, TRANSFER_TRANSACTION_ID
, WAYBILL_AIRBILL
, TRANSFER_COST
, TRANSPORTATION_COST
, TRANSFER_PERCENTAGE
, TRANSFER_COST_GROUP_ID
FROM BOM.CST_PAC_INTERORG_TXNS_TMP#;
|
|
|