VIEW: APPS.CSD_RETURNS_BI_MTL_TXNS_V

Source

View Text - Preformatted

SELECT txn.transaction_id, txn.organization_id inventory_org_id, txn.inventory_item_id, mtl.concatenated_segments inventory_item_desc, mtl.primary_uom_code, txn.transaction_quantity, txn.transaction_uom transaction_uom_code, trunc(txn.transaction_date) transaction_date, txn.reason_id, dis.mtl_disposition_code, (mtl.unit_weight*csd_returns_bi_util.convert_inv_uom( txn.transaction_quantity, txn.transaction_uom, mtl.primary_uom_code , null )) transacted_weight, mtl.weight_uom_code, orgv.operating_unit from mtl_material_transactions txn, mtl_system_items_kfv mtl, csd_mtl_disposition_reasons dis, org_organization_definitions orgv WHERE txn.inventory_item_id = mtl.inventory_item_id and txn.organization_id = mtl.organization_id and txn.transaction_type_id = 43 and txn.reason_id = dis.mtl_txn_reason_id and txn.organization_id = orgv.organization_id union all select txn.transaction_id, txn.organization_id inventory_org_id, txn.inventory_item_id, mtl.concatenated_segments inventory_item_desc, mtl.primary_uom_code, txn.transaction_quantity, txn.transaction_uom transaction_uom_code, trunc(txn.transaction_date) transaction_date, txn.reason_id, dis.mtl_disposition_code, (mtl.unit_weight*csd_returns_bi_util.convert_inv_uom( txn.transaction_quantity, txn.transaction_uom, mtl.primary_uom_code , null )) transacted_weight, mtl.weight_uom_code, orgv.operating_unit from mtl_material_transactions txn, mtl_system_items_kfv mtl, csd_mtl_disposition_reasons dis, org_organization_definitions orgv where txn.inventory_item_id = mtl.inventory_item_id and txn.organization_id = mtl.organization_id and txn.transaction_type_id =38 and txn.reason_id = dis.mtl_txn_reason_id and txn.organization_id = orgv.organization_id

View Text - HTML Formatted

SELECT TXN.TRANSACTION_ID
, TXN.ORGANIZATION_ID INVENTORY_ORG_ID
, TXN.INVENTORY_ITEM_ID
, MTL.CONCATENATED_SEGMENTS INVENTORY_ITEM_DESC
, MTL.PRIMARY_UOM_CODE
, TXN.TRANSACTION_QUANTITY
, TXN.TRANSACTION_UOM TRANSACTION_UOM_CODE
, TRUNC(TXN.TRANSACTION_DATE) TRANSACTION_DATE
, TXN.REASON_ID
, DIS.MTL_DISPOSITION_CODE
, (MTL.UNIT_WEIGHT*CSD_RETURNS_BI_UTIL.CONVERT_INV_UOM( TXN.TRANSACTION_QUANTITY
, TXN.TRANSACTION_UOM
, MTL.PRIMARY_UOM_CODE
, NULL )) TRANSACTED_WEIGHT
, MTL.WEIGHT_UOM_CODE
, ORGV.OPERATING_UNIT
FROM MTL_MATERIAL_TRANSACTIONS TXN
, MTL_SYSTEM_ITEMS_KFV MTL
, CSD_MTL_DISPOSITION_REASONS DIS
, ORG_ORGANIZATION_DEFINITIONS ORGV
WHERE TXN.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND TXN.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND TXN.TRANSACTION_TYPE_ID = 43
AND TXN.REASON_ID = DIS.MTL_TXN_REASON_ID
AND TXN.ORGANIZATION_ID = ORGV.ORGANIZATION_ID UNION ALL SELECT TXN.TRANSACTION_ID
, TXN.ORGANIZATION_ID INVENTORY_ORG_ID
, TXN.INVENTORY_ITEM_ID
, MTL.CONCATENATED_SEGMENTS INVENTORY_ITEM_DESC
, MTL.PRIMARY_UOM_CODE
, TXN.TRANSACTION_QUANTITY
, TXN.TRANSACTION_UOM TRANSACTION_UOM_CODE
, TRUNC(TXN.TRANSACTION_DATE) TRANSACTION_DATE
, TXN.REASON_ID
, DIS.MTL_DISPOSITION_CODE
, (MTL.UNIT_WEIGHT*CSD_RETURNS_BI_UTIL.CONVERT_INV_UOM( TXN.TRANSACTION_QUANTITY
, TXN.TRANSACTION_UOM
, MTL.PRIMARY_UOM_CODE
, NULL )) TRANSACTED_WEIGHT
, MTL.WEIGHT_UOM_CODE
, ORGV.OPERATING_UNIT
FROM MTL_MATERIAL_TRANSACTIONS TXN
, MTL_SYSTEM_ITEMS_KFV MTL
, CSD_MTL_DISPOSITION_REASONS DIS
, ORG_ORGANIZATION_DEFINITIONS ORGV
WHERE TXN.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
AND TXN.ORGANIZATION_ID = MTL.ORGANIZATION_ID
AND TXN.TRANSACTION_TYPE_ID =38
AND TXN.REASON_ID = DIS.MTL_TXN_REASON_ID
AND TXN.ORGANIZATION_ID = ORGV.ORGANIZATION_ID