VIEW: APPS.CSM_MTL_MATERIAL_TXNS_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.GET_NUMBER( acc.access_id) , mmt.transaction_id, CSM_UTIL_PKG.GET_NUMBER(mmt.inventory_item_id) , mmt.revision , CSM_UTIL_PKG.GET_NUMBER(mmt.organization_id) , mmt.subinventory_code , mmt.locator_id , CSM_UTIL_PKG.GET_NUMBER(mmt.transaction_type_id) , CSM_UTIL_PKG.GET_NUMBER(mmt.transaction_action_id) , CSM_UTIL_PKG.GET_NUMBER(mmt.transaction_source_type_id) , CSM_UTIL_PKG.GET_NUMBER(mmt.transaction_quantity) , CSM_UTIL_PKG.GET_VARCHAR(mmt.transaction_uom) , CSM_UTIL_PKG.GET_NUMBER(mmt.primary_quantity) , CSM_UTIL_PKG.GET_DATE(mmt.transaction_date) , mmt.transaction_reference , mmt.reason_id , mmt.transfer_organization_id , mmt.transfer_subinventory , mmt.transfer_locator_id FROM csm_mtl_material_txn_acc acc, mtl_material_transactions mmt WHERE acc.user_id = asg_base.get_user_id AND acc.transaction_id = mmt.transaction_id

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER( ACC.ACCESS_ID)
, MMT.TRANSACTION_ID
, CSM_UTIL_PKG.GET_NUMBER(MMT.INVENTORY_ITEM_ID)
, MMT.REVISION
, CSM_UTIL_PKG.GET_NUMBER(MMT.ORGANIZATION_ID)
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, CSM_UTIL_PKG.GET_NUMBER(MMT.TRANSACTION_TYPE_ID)
, CSM_UTIL_PKG.GET_NUMBER(MMT.TRANSACTION_ACTION_ID)
, CSM_UTIL_PKG.GET_NUMBER(MMT.TRANSACTION_SOURCE_TYPE_ID)
, CSM_UTIL_PKG.GET_NUMBER(MMT.TRANSACTION_QUANTITY)
, CSM_UTIL_PKG.GET_VARCHAR(MMT.TRANSACTION_UOM)
, CSM_UTIL_PKG.GET_NUMBER(MMT.PRIMARY_QUANTITY)
, CSM_UTIL_PKG.GET_DATE(MMT.TRANSACTION_DATE)
, MMT.TRANSACTION_REFERENCE
, MMT.REASON_ID
, MMT.TRANSFER_ORGANIZATION_ID
, MMT.TRANSFER_SUBINVENTORY
, MMT.TRANSFER_LOCATOR_ID
FROM CSM_MTL_MATERIAL_TXN_ACC ACC
, MTL_MATERIAL_TRANSACTIONS MMT
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.TRANSACTION_ID = MMT.TRANSACTION_ID