VIEW: APPS.CSM_MTL_UNIT_TXNS_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.GET_NUMBER(acc.access_id) , mut.transaction_id , mut.serial_number , CSM_UTIL_PKG.GET_NUMBER(mut.inventory_item_id) , CSM_UTIL_PKG.GET_NUMBER(mut.organization_id) , mut.subinventory_code, mut.locator_id FROM csm_mtl_unit_txn_acc acc, mtl_unit_transactions mut WHERE acc.user_id = asg_base.get_user_id AND acc.transaction_id = mut.transaction_id AND acc.serial_number = mut.serial_number AND mut.organization_id = csm_profile_pkg.get_organization_id(acc.user_id)

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID)
, MUT.TRANSACTION_ID
, MUT.SERIAL_NUMBER
, CSM_UTIL_PKG.GET_NUMBER(MUT.INVENTORY_ITEM_ID)
, CSM_UTIL_PKG.GET_NUMBER(MUT.ORGANIZATION_ID)
, MUT.SUBINVENTORY_CODE
, MUT.LOCATOR_ID
FROM CSM_MTL_UNIT_TXN_ACC ACC
, MTL_UNIT_TRANSACTIONS MUT
WHERE ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ACC.TRANSACTION_ID = MUT.TRANSACTION_ID
AND ACC.SERIAL_NUMBER = MUT.SERIAL_NUMBER
AND MUT.ORGANIZATION_ID = CSM_PROFILE_PKG.GET_ORGANIZATION_ID(ACC.USER_ID)