DBA Data[Home] [Help]

APPS.CSE_ASSET_MOVE_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 3170: ,mtl_system_items_b msib

3166: IS
3167: SELECT DECODE (msib.serial_number_control_code,1,'NON-SERIAL',
3168: 2, 'SERIAL', 5 ,'SERIAL',6, 'NON-SERIAL','NON-SERIAL') serial_control_code
3169: FROM mtl_material_transactions mmt
3170: ,mtl_system_items_b msib
3171: WHERE mmt.transaction_id = p_mtl_transaction_id
3172: AND mmt.inventory_item_id = msib.inventory_item_id
3173: AND mmt.organization_id = msib.organization_id ;
3174:

Line 3180: ,mtl_system_items_b msib

3176: IS
3177: SELECT DECODE (msib.serial_number_control_code,1,'NON-SERIAL',
3178: 2, 'SERIAL', 5 ,'SERIAL',6, 'NON-SERIAL','NON-SERIAL') serial_control_code
3179: FROM mtl_material_transactions mmt
3180: ,mtl_system_items_b msib
3181: WHERE mmt.transaction_id = p_mtl_transaction_id
3182: AND mmt.inventory_item_id = msib.inventory_item_id
3183: AND mmt.transfer_organization_id = msib.organization_id ;
3184: