APPS.ASO_QUOTE_LINES_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1210: from mtl_system_items_b

1206:
1207: CURSOR C_item1(inv1 NUMBER, lc_organization_id NUMBER) IS
1208: select primary_uom_code, service_item_flag,serviceable_product_flag,ship_model_complete_flag,
1209: payment_terms_id,config_model_type
1210: from mtl_system_items_b
1211: where inventory_item_id = inv1
1212: and organization_id = lc_organization_id;
1213:
1214: CURSOR C_shipment IS

Line 1270: FROM mtl_system_items_b

1266:
1267: -- Recurring charges Change
1268: CURSOR c_periodicity(p_inventory_item_id IN Number, p_organization_id IN Number) IS
1269: SELECT charge_periodicity_code
1270: FROM mtl_system_items_b
1271: WHERE inventory_item_id = p_inventory_item_id
1272: AND organization_id = p_organization_id;
1273:
1274: Cursor get_hdr_term(l_qte_hdr_id number) is

Line 1407: FROM mtl_system_items_b i

1403: IF l_qte_line_rec.item_type_code is NULL OR l_qte_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN
1404:
1405: SELECT Decode(i.bom_item_type , 1, 'MDL',2,'OPT',3,'PLN',4,'STD')
1406: INTO l_qte_line_rec.item_type_code
1407: FROM mtl_system_items_b i
1408: WHERE inventory_item_id = l_qte_line_rec.inventory_item_id
1409: AND organization_id = l_qte_line_rec.organization_id;
1410:
1411: IF (SQL%NOTFOUND) THEN

Line 2607: SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID FROM mtl_system_items_b

2603: FROM ASO_QUOTE_HEADERS_ALL
2604: WHERE QUOTE_HEADER_ID = cust_QUOTE_HEADER_ID;
2605:
2606: CURSOR c_reservation(C_inv_item_id NUMBER,C_Organization_id NUMBER) IS
2607: SELECT INVENTORY_ITEM_ID,ORGANIZATION_ID FROM mtl_system_items_b
2608: WHERE RESERVABLE_TYPE =1 AND
2609: MTL_TRANSACTIONS_ENABLED_FLAG = 'Y' AND
2610: INVENTORY_ITEM_ID= C_inv_item_id AND
2611: ORGANIZATION_ID = C_Organization_id;

Line 2640: from mtl_system_items_b

2636: --End of new code for Bug # 2498942 fix
2637:
2638: Cursor c_container_item_check (C_inv_item_id NUMBER,C_Organization_id NUMBER) IS
2639: select config_model_type
2640: from mtl_system_items_b
2641: where INVENTORY_ITEM_ID= C_inv_item_id
2642: AND ORGANIZATION_ID = C_Organization_id;
2643:
2644: