APPS.ASO_OPP_QTE_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 249: FROM MTL_SYSTEM_ITEMS_B

245: AND b.quote_number =c.quote_number;
246:
247: CURSOR c_base_valid(p_item_id IN Number,p_organization_id IN Number) IS
248: SELECT primary_uom_code
249: FROM MTL_SYSTEM_ITEMS_B
250: WHERE inventory_item_id = p_item_id
251: AND organization_id = p_organization_id;
252:
253: CURSOR c_pay_term_aggrement(p_agreement_id IN Number) IS

Line 286: FROM mtl_system_items_b

282: -- Recurring charges Change
283:
284: CURSOR c_periodicity(p_inventory_item_id IN Number, p_organization_id IN Number) IS
285: SELECT charge_periodicity_code
286: FROM mtl_system_items_b
287: WHERE inventory_item_id = p_inventory_item_id
288: AND organization_id = p_organization_id;
289:
290: CURSOR c_serv_item (l_inventory_item_id NUMBER, l_organization_id NUMBER) IS

Line 1598: l_uom_code MTL_SYSTEM_ITEMS_B.primary_uom_code%TYPE;

1594: AND organization_id = l_organization_id;
1595:
1596: l_conc_segments VARCHAR2(40);
1597: l_orderable_flag VARCHAR2(1) := 'N';
1598: l_uom_code MTL_SYSTEM_ITEMS_B.primary_uom_code%TYPE;
1599: l_resp_id NUMBER;
1600: l_resp_appl_id NUMBER;
1601: l_ui_def_id NUMBER;
1602: l_output_qty NUMBER;