APPS.JAI_PO_OSP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 181: FROM mtl_system_items

177:
178: /* Bug 7028169. Changed the cursor definition */
179: CURSOR c_get_item_details(cp_org_id NUMBER, cp_item_id NUMBER) IS
180: SELECT *
181: FROM mtl_system_items
182: WHERE organization_id = cp_org_id
183: AND inventory_item_id = cp_item_id;
184:
185: --**********************ITEM VALUE*****************************

Line 214: FROM mtl_system_items

210: AND NVL( End_Date_Active, SYSDATE + 1 ) >= SYSDATE;
211: --**********************ITEM VALUE2*****************************
212: CURSOR c_item_value2(cp_item_id NUMBER, cp_org_id NUMBER) IS
213: SELECT list_price_per_unit
214: FROM mtl_system_items
215: WHERE inventory_item_id = cp_item_id AND organization_id = cp_org_id;
216: --**********************ITEM COST******************************* GSN
217: CURSOR c_item_cost(cp_item_id NUMBER, cp_org_id NUMBER) IS
218: SELECT cic.item_cost

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

1229: from po_distributions_all
1230: where po_header_id = p_po_hdr_id
1231: and po_line_id = p_po_line_id;
1232:
1233: v_item_pr_uom_code mtl_system_items.primary_uom_code%TYPE; -- eg. Ea
1234: v_item_pr_uom mtl_system_items.primary_unit_of_measure%TYPE; -- eg. Each
1235:
1236: CURSOR c_item_pr_uom( p_organization_id IN NUMBER, p_inv_item_id IN NUMBER) IS
1237: SELECT primary_uom_code, primary_unit_of_measure

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

1230: where po_header_id = p_po_hdr_id
1231: and po_line_id = p_po_line_id;
1232:
1233: v_item_pr_uom_code mtl_system_items.primary_uom_code%TYPE; -- eg. Ea
1234: v_item_pr_uom mtl_system_items.primary_unit_of_measure%TYPE; -- eg. Each
1235:
1236: CURSOR c_item_pr_uom( p_organization_id IN NUMBER, p_inv_item_id IN NUMBER) IS
1237: SELECT primary_uom_code, primary_unit_of_measure
1238: FROM mtl_system_items

Line 1238: FROM mtl_system_items

1234: v_item_pr_uom mtl_system_items.primary_unit_of_measure%TYPE; -- eg. Each
1235:
1236: CURSOR c_item_pr_uom( p_organization_id IN NUMBER, p_inv_item_id IN NUMBER) IS
1237: SELECT primary_uom_code, primary_unit_of_measure
1238: FROM mtl_system_items
1239: WHERE organization_id = p_organization_id
1240: AND inventory_item_id = p_inv_item_id;
1241:
1242: --**********VARIABLE DECLARATION**********

Line 1288: FROM mtl_system_items

1284:
1285: /* Bug 7028169. Added by Lakshmi Gopalsami */
1286: CURSOR c_get_item_details(cp_org_id NUMBER, cp_item_id NUMBER) IS
1287: SELECT *
1288: FROM mtl_system_items
1289: WHERE organization_id = cp_org_id
1290: AND inventory_item_id = cp_item_id;
1291:
1292: r_get_po_item_details c_get_item_details%ROWTYPE;