VIEW: BOM.CST_PAC_INTERORG_TXNS_TMP#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, COST_GROUP_ID COST_GROUP_ID, PAC_PERIOD_ID PAC_PERIOD_ID, TXN_TYPE TXN_TYPE, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PRIMARY_QUANTITY PRIMARY_QUANTITY, PERIODIC_PRIMARY_QUANTITY PERIODIC_PRIMARY_QUANTITY, ORGANIZATION_ID ORGANIZATION_ID, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, TRANSFER_PRICE TRANSFER_PRICE, SHIPMENT_NUMBER SHIPMENT_NUMBER, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID, WAYBILL_AIRBILL WAYBILL_AIRBILL, TRANSFER_COST TRANSFER_COST, TRANSPORTATION_COST TRANSPORTATION_COST, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID from "BOM"."CST_PAC_INTERORG_TXNS_TMP"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, COST_GROUP_ID COST_GROUP_ID
, PAC_PERIOD_ID PAC_PERIOD_ID
, TXN_TYPE TXN_TYPE
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, PERIODIC_PRIMARY_QUANTITY PERIODIC_PRIMARY_QUANTITY
, ORGANIZATION_ID ORGANIZATION_ID
, TRANSFER_ORGANIZATION_ID TRANSFER_ORGANIZATION_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, TRANSFER_PRICE TRANSFER_PRICE
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, TRANSFER_TRANSACTION_ID TRANSFER_TRANSACTION_ID
, WAYBILL_AIRBILL WAYBILL_AIRBILL
, TRANSFER_COST TRANSFER_COST
, TRANSPORTATION_COST TRANSPORTATION_COST
, TRANSFER_PERCENTAGE TRANSFER_PERCENTAGE
, TRANSFER_COST_GROUP_ID TRANSFER_COST_GROUP_ID
FROM "BOM"."CST_PAC_INTERORG_TXNS_TMP"