APPS.CSE_ASSET_MOVE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1589: mtl_system_items msi

1585: mmt.primary_quantity,
1586: msi.serial_number_control_code,
1587: msi.primary_unit_of_measure
1588: FROM mtl_material_transactions mmt,
1589: mtl_system_items msi
1590: WHERE mmt.transaction_id = p_mtl_txn_id
1591: AND msi.inventory_item_id = mmt.inventory_item_id
1592: AND msi.organization_id = mmt.organization_id;
1593:

Line 1602: mtl_system_items msi

1598: msi.serial_number_control_code,
1599: msi.primary_unit_of_measure
1600: FROM csi_item_instances_h ciih,
1601: csi_item_instances cii,
1602: mtl_system_items msi
1603: WHERE ciih.transaction_id = p_transaction_id
1604: AND cii.instance_id = ciih.instance_id
1605: AND msi.inventory_item_id = cii.inventory_item_id
1606: AND msi.organization_id = cii.last_vld_organization_id;

Line 2220: FROM mtl_system_items

2216: IF p_dest_move_trans_tbl(d_ind).inv_organization_id <> p_src_move_trans_tbl(s_ind).inv_organization_id
2217: THEN
2218: SELECT asset_category_id
2219: INTO l_dest_fa_category_id
2220: FROM mtl_system_items
2221: WHERE inventory_item_id = p_dest_move_trans_tbl(d_ind).inv_item_id
2222: AND organization_id = p_dest_move_trans_tbl(d_ind).inv_organization_id;
2223: END IF;
2224: END IF ;

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:

Line 3862: FROM mtl_system_items_kfv

3858: l_primary_uom_code,
3859: l_asset_creation_code,
3860: l_item_description,
3861: l_item
3862: FROM mtl_system_items_kfv
3863: WHERE inventory_item_id = l_inventory_item_id
3864: AND organization_id = l_organization_id;
3865:
3866: IF nvl(l_asset_creation_code,'0') in ('1', 'Y') THEN