APPS.CSE_ASSET_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 43: FROM mtl_system_items_b

39: BEGIN
40:
41: SELECT nvl(inventory_asset_flag, 'N')
42: INTO l_inventory_asset_flag
43: FROM mtl_system_items_b
44: WHERE inventory_item_id = p_inventory_item_id
45: AND organization_id = p_organization_id;
46:
47: IF l_inventory_asset_flag = 'N' THEN

Line 81: FROM mtl_system_items_b msib

77: -- have asset for multiple items
78:
79: CURSOR asset_description_cur (c_org_id IN NUMBER,c_inv_item_id IN NUMBER) IS
80: SELECT substr(msib.description,1,80) asset_description
81: FROM mtl_system_items_b msib
82: WHERE msib.organization_id = c_org_id
83: AND msib.inventory_item_id = c_inv_item_id ;
84:
85: BEGIN

Line 345: FROM mtl_system_items_b msib,

341: CURSOR dpi_cur (p_csi_txn_id IN NUMBER, p_inst_id IN number) IS
342: SELECT msib.asset_creation_code,
343: msib.serial_number_control_code,
344: citdv.source_transaction_date
345: FROM mtl_system_items_b msib,
346: csi_inst_txn_details_v citdv
347: WHERE msib.organization_id = citdv.inv_master_organization_id
348: AND msib.inventory_item_id = citdv.inventory_item_id
349: AND citdv.transaction_id = p_csi_txn_id

Line 993: mtl_system_items msi

989: mmt.organization_id
990: INTO l_inventory_asset_flag,
991: l_organization_id
992: FROM mtl_material_transactions mmt,
993: mtl_system_items msi
994: WHERE mmt.transaction_id = l_mtl_txn_id
995: AND msi.inventory_item_id = mmt.inventory_item_id
996: AND msi.organization_id = mmt.organization_id;
997:

Line 1422: FROM mtl_system_items_b msib

1418:
1419: /*CURSOR catchup_cur (c_instance_asset_id IN NUMBER)
1420: IS
1421: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1422: FROM mtl_system_items_b msib
1423: ,csi_item_instances cii
1424: ,csi_i_assets cia
1425: WHERE msib.organization_id = cii.inv_master_organization_id
1426: AND msib.inventory_item_id = cii.inventory_item_id

Line 1434: FROM mtl_system_items_b msib

1430:
1431: CURSOR catchup_cur (c_instance_asset_id IN NUMBER,c_inv_org_id IN NUMBER,c_inv_item_id IN NUMBER, c_inst_id IN NUMBER)
1432: IS
1433: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1434: FROM mtl_system_items_b msib
1435: ,csi_i_assets cia
1436: WHERE msib.organization_id = c_inv_org_id
1437: AND msib.inventory_item_id = c_inv_item_id
1438: AND cia.instance_id = c_inst_id

Line 1487: FROM mtl_system_items_b msib

1483:
1484:
1485: CURSOR item_type_cur(c_inv_org_id IN NUMBER,c_inv_item_id IN NUMBER) IS
1486: SELECT NVL(msib.asset_creation_code,'~')
1487: FROM mtl_system_items_b msib
1488: WHERE msib.organization_id = c_inv_org_id
1489: AND msib.inventory_item_id = c_inv_item_id;
1490:
1491: