CST Historical Intransit Standard Cost Adjustment

Description
Categories: BI Publisher
Columns: Organization Id, From Org Code, From Org Name, To Org Code, To Org Name, Item Number, Item Desc, UOM Code, Intransit Acct, Adjustment Acct ...
Application: Bills of Material
Source: Historical Intransit Standard Cost Adjustment Report (XML)
Short Name: CSTCUSTA_XML
DB package: BOM_CSTRUSTA_XMLP_PKG
SELECT  C.ORGANIZATION_ID ORGANIZATION_ID
,       OFROM.ORGANIZATION_CODE FROM_ORG_CODE
,       OFROM.ORGANIZATION_NAME FROM_ORG_NAME
,       OTO.ORGANIZATION_CODE TO_ORG_CODE
,       OTO.ORGANIZATION_NAME TO_ORG_NAME
,       null ITEM_NUMBER
,       MSI.DESCRIPTION ITEM_DESC
,       MSI.PRIMARY_UOM_CODE UOM_CODE
,       null INTRANSIT_ACCT
,       null ADJUSTMENT_ACCT
,       ROUND(C.ADJUSTMENT_QUANTITY,:P_qty_precision) ADJUSTMENT_QUANTITY, 
        C.OLD_UNIT_COST
,       C.NEW_UNIT_COST
,       ROUND(C