DBA Data[Home] [Help]

APPS.CSE_ASSET_MOVE_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 3249: ,mtl_system_items_b msib

3245: IS
3246: SELECT DECODE (msib.serial_number_control_code,1,'NON-SERIAL',
3247: 2, 'SERIAL', 5 ,'SERIAL',6, 'NON-SERIAL','NON-SERIAL') serial_control_code
3248: FROM mtl_material_transactions mmt
3249: ,mtl_system_items_b msib
3250: WHERE mmt.transaction_id = p_mtl_transaction_id
3251: AND mmt.inventory_item_id = msib.inventory_item_id
3252: AND mmt.organization_id = msib.organization_id ;
3253:

Line 3259: ,mtl_system_items_b msib

3255: IS
3256: SELECT DECODE (msib.serial_number_control_code,1,'NON-SERIAL',
3257: 2, 'SERIAL', 5 ,'SERIAL',6, 'NON-SERIAL','NON-SERIAL') serial_control_code
3258: FROM mtl_material_transactions mmt
3259: ,mtl_system_items_b msib
3260: WHERE mmt.transaction_id = p_mtl_transaction_id
3261: AND mmt.inventory_item_id = msib.inventory_item_id
3262: AND mmt.transfer_organization_id = msib.organization_id ;
3263: