APPS.JAI_PO_OSP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 240: FROM mtl_system_items

236:
237: /* Bug 7028169. Changed the cursor definition */
238: CURSOR c_get_item_details(cp_org_id NUMBER, cp_item_id NUMBER) IS
239: SELECT *
240: FROM mtl_system_items
241: WHERE organization_id = cp_org_id
242: AND inventory_item_id = cp_item_id;
243:
244: --**********************ITEM VALUE*****************************

Line 273: FROM mtl_system_items

269: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
270: --**********************ITEM VALUE2*****************************
271: CURSOR c_item_value2(cp_item_id NUMBER, cp_org_id NUMBER) IS
272: SELECT list_price_per_unit
273: FROM mtl_system_items
274: WHERE inventory_item_id = cp_item_id AND organization_id = cp_org_id;
275: --**********************ITEM COST******************************* GSN
276: CURSOR c_item_cost(cp_item_id NUMBER, cp_org_id NUMBER) IS
277: SELECT cic.item_cost

Line 1375: v_item_pr_uom_code mtl_system_items.primary_uom_code%TYPE; -- eg. Ea

1371: from po_distributions_all
1372: where po_header_id = p_po_hdr_id
1373: and po_line_id = p_po_line_id;
1374:
1375: v_item_pr_uom_code mtl_system_items.primary_uom_code%TYPE; -- eg. Ea
1376: v_item_pr_uom mtl_system_items.primary_unit_of_measure%TYPE; -- eg. Each
1377:
1378: CURSOR c_item_pr_uom( p_organization_id IN NUMBER, p_inv_item_id IN NUMBER) IS
1379: SELECT primary_uom_code, primary_unit_of_measure

Line 1376: v_item_pr_uom mtl_system_items.primary_unit_of_measure%TYPE; -- eg. Each

1372: where po_header_id = p_po_hdr_id
1373: and po_line_id = p_po_line_id;
1374:
1375: v_item_pr_uom_code mtl_system_items.primary_uom_code%TYPE; -- eg. Ea
1376: v_item_pr_uom mtl_system_items.primary_unit_of_measure%TYPE; -- eg. Each
1377:
1378: CURSOR c_item_pr_uom( p_organization_id IN NUMBER, p_inv_item_id IN NUMBER) IS
1379: SELECT primary_uom_code, primary_unit_of_measure
1380: FROM mtl_system_items

Line 1380: FROM mtl_system_items

1376: v_item_pr_uom mtl_system_items.primary_unit_of_measure%TYPE; -- eg. Each
1377:
1378: CURSOR c_item_pr_uom( p_organization_id IN NUMBER, p_inv_item_id IN NUMBER) IS
1379: SELECT primary_uom_code, primary_unit_of_measure
1380: FROM mtl_system_items
1381: WHERE organization_id = p_organization_id
1382: AND inventory_item_id = p_inv_item_id;
1383:
1384: --**********VARIABLE DECLARATION**********

Line 1437: FROM mtl_system_items

1433:
1434: /* Bug 7028169. Added by Lakshmi Gopalsami */
1435: CURSOR c_get_item_details(cp_org_id NUMBER, cp_item_id NUMBER) IS
1436: SELECT *
1437: FROM mtl_system_items
1438: WHERE organization_id = cp_org_id
1439: AND inventory_item_id = cp_item_id;
1440:
1441: r_get_po_item_details c_get_item_details%ROWTYPE;