APPS.CSE_ASSET_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 48: FROM mtl_system_items_b

44: debug('inside get_item_cost'); --Added for bug 13524676
45:
46: SELECT nvl(inventory_asset_flag, 'N')
47: INTO l_inventory_asset_flag
48: FROM mtl_system_items_b
49: WHERE inventory_item_id = p_inventory_item_id
50: AND organization_id = p_organization_id;
51:
52: debug(' inventory_asset_flag : '||l_inventory_asset_flag);

Line 125: FROM mtl_system_items_b msib

121: -- have asset for multiple items
122:
123: CURSOR asset_description_cur (c_org_id IN NUMBER,c_inv_item_id IN NUMBER) IS
124: SELECT substr(msib.description,1,80) asset_description
125: FROM mtl_system_items_b msib
126: WHERE msib.organization_id = c_org_id
127: AND msib.inventory_item_id = c_inv_item_id ;
128:
129: BEGIN

Line 389: FROM mtl_system_items_b msib,

385: CURSOR dpi_cur (p_csi_txn_id IN NUMBER, p_inst_id IN number) IS
386: SELECT msib.asset_creation_code,
387: msib.serial_number_control_code,
388: citdv.source_transaction_date
389: FROM mtl_system_items_b msib,
390: csi_inst_txn_details_v citdv
391: WHERE msib.organization_id = citdv.inv_master_organization_id
392: AND msib.inventory_item_id = citdv.inventory_item_id
393: AND citdv.transaction_id = p_csi_txn_id

Line 1057: mtl_system_items msi

1053: l_organization_id,
1054: l_subinventory_code,
1055: l_txn_source_id -- Added for bug#16365883
1056: FROM mtl_material_transactions mmt,
1057: mtl_system_items msi
1058: WHERE mmt.transaction_id = l_mtl_txn_id
1059: AND msi.inventory_item_id = mmt.inventory_item_id
1060: AND msi.organization_id = mmt.organization_id;
1061:

Line 1547: FROM mtl_system_items_b msib

1543:
1544: /*CURSOR catchup_cur (c_instance_asset_id IN NUMBER)
1545: IS
1546: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1547: FROM mtl_system_items_b msib
1548: ,csi_item_instances cii
1549: ,csi_i_assets cia
1550: WHERE msib.organization_id = cii.inv_master_organization_id
1551: AND msib.inventory_item_id = cii.inventory_item_id

Line 1559: FROM mtl_system_items_b msib

1555:
1556: 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)
1557: IS
1558: SELECT DECODE(msib.asset_creation_code,'1','N','Y')
1559: FROM mtl_system_items_b msib
1560: ,csi_i_assets cia
1561: WHERE msib.organization_id = c_inv_org_id
1562: AND msib.inventory_item_id = c_inv_item_id
1563: AND cia.instance_id = c_inst_id

Line 1612: FROM mtl_system_items_b msib

1608:
1609:
1610: CURSOR item_type_cur(c_inv_org_id IN NUMBER,c_inv_item_id IN NUMBER) IS
1611: SELECT NVL(msib.asset_creation_code,'~')
1612: FROM mtl_system_items_b msib
1613: WHERE msib.organization_id = c_inv_org_id
1614: AND msib.inventory_item_id = c_inv_item_id;
1615:
1616: