APPS.CSE_ASSET_MOVE_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1550: mtl_system_items msi

1546: mmt.primary_quantity,
1547: msi.serial_number_control_code,
1548: msi.primary_unit_of_measure
1549: FROM mtl_material_transactions mmt,
1550: mtl_system_items msi
1551: WHERE mmt.transaction_id = p_mtl_txn_id
1552: AND msi.inventory_item_id = mmt.inventory_item_id
1553: AND msi.organization_id = mmt.organization_id;
1554:

Line 1563: mtl_system_items msi

1559: msi.serial_number_control_code,
1560: msi.primary_unit_of_measure
1561: FROM csi_item_instances_h ciih,
1562: csi_item_instances cii,
1563: mtl_system_items msi
1564: WHERE ciih.transaction_id = p_transaction_id
1565: AND cii.instance_id = ciih.instance_id
1566: AND msi.inventory_item_id = cii.inventory_item_id
1567: AND msi.organization_id = cii.last_vld_organization_id;

Line 2148: FROM mtl_system_items

2144: IF p_dest_move_trans_tbl(d_ind).inv_organization_id <> p_src_move_trans_tbl(s_ind).inv_organization_id
2145: THEN
2146: SELECT asset_category_id
2147: INTO l_dest_fa_category_id
2148: FROM mtl_system_items
2149: WHERE inventory_item_id = p_dest_move_trans_tbl(d_ind).inv_item_id
2150: AND organization_id = p_dest_move_trans_tbl(d_ind).inv_organization_id;
2151: END IF;
2152: END IF ;

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:

Line 3772: FROM mtl_system_items_kfv

3768: l_primary_uom_code,
3769: l_asset_creation_code,
3770: l_item_description,
3771: l_item
3772: FROM mtl_system_items_kfv
3773: WHERE inventory_item_id = l_inventory_item_id
3774: AND organization_id = l_organization_id;
3775:
3776: IF nvl(l_asset_creation_code,'0') in ('1', 'Y') THEN