eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMDFMVAL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;

151: xreturn_code OUT NOCOPY NUMBER) IS
152:
153: /* Local variables. */
154: /* ================ */
155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;
156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;
157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS

Line 156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;

152:
153: /* Local variables. */
154: /* ================ */
155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;
156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;
157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS
160: SELECT inventory_item_id, primary_uom_code, enabled_flag

Line 157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;

153: /* Local variables. */
154: /* ================ */
155: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;
156: l_item_um mtl_system_items_kfv.primary_uom_code%TYPE := NULL;
157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS
160: SELECT inventory_item_id, primary_uom_code, enabled_flag
161: FROM mtl_system_items_kfv

Line 161: FROM mtl_system_items_kfv

157: l_enabled_flag mtl_system_items_kfv.enabled_flag%TYPE := 0;
158:
159: CURSOR get_id IS
160: SELECT inventory_item_id, primary_uom_code, enabled_flag
161: FROM mtl_system_items_kfv
162: WHERE concatenated_segments = pitem_no
163: AND organization_id = porganization_id;
164:
165: CURSOR get_it_id IS

Line 167: FROM mtl_system_items

163: AND organization_id = porganization_id;
164:
165: CURSOR get_it_id IS
166: SELECT inventory_item_id, primary_uom_code, enabled_flag
167: FROM mtl_system_items
168: WHERE inventory_item_id = pinventory_item_id
169: AND organization_id = porganization_id;
170:
171: BEGIN

Line 264: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;

260: xreturn_code OUT NOCOPY NUMBER) IS
261:
262: /* Local variables. */
263: /* ================ */
264: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
265: l_um mtl_system_items.primary_uom_code%TYPE := NULL;
266:
267: /* Cursor Definitions. */
268: /* =================== */

Line 265: l_um mtl_system_items.primary_uom_code%TYPE := NULL;

261:
262: /* Local variables. */
263: /* ================ */
264: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
265: l_um mtl_system_items.primary_uom_code%TYPE := NULL;
266:
267: /* Cursor Definitions. */
268: /* =================== */
269: CURSOR get_product IS

Line 277: FROM mtl_system_items_kfv

273: AND line_type = 1;
274:
275: CURSOR get_uom IS
276: SELECT primary_uom_code
277: FROM mtl_system_items_kfv
278: WHERE inventory_item_id = l_item_id;
279:
280: /* ================================================ */
281: BEGIN

Line 740: litem_id mtl_system_items.inventory_item_id%TYPE;

736: xTable_out OUT NOCOPY formula_table_out,
737: xReturn OUT NOCOPY VARCHAR2) IS
738:
739: /* Local variables */
740: litem_id mtl_system_items.inventory_item_id%TYPE;
741: litem_um mtl_system_items.primary_uom_code%TYPE;
742: l_return_code NUMBER;
743: X_count NUMBER := 1;
744:

Line 741: litem_um mtl_system_items.primary_uom_code%TYPE;

737: xReturn OUT NOCOPY VARCHAR2) IS
738:
739: /* Local variables */
740: litem_id mtl_system_items.inventory_item_id%TYPE;
741: litem_um mtl_system_items.primary_uom_code%TYPE;
742: l_return_code NUMBER;
743: X_count NUMBER := 1;
744:
745: l_formula_id NUMBER;

Line 1660: FROM mtl_system_items

1656: xReturn OUT NOCOPY VARCHAR2) IS
1657: --Cursor Declaration
1658: CURSOR Cur_get_revision(Vitem_id NUMBER, Vorgn_id NUMBER) IS
1659: SELECT revision_qty_control_code
1660: FROM mtl_system_items
1661: WHERE inventory_item_id = Vitem_id
1662: AND organization_id = Vorgn_id;
1663: -- Bug 5350197 Added
1664: CURSOR Cur_get_serial_control(Vitem_id NUMBER, Vorgn_id NUMBER) IS

Line 1666: FROM mtl_system_items

1662: AND organization_id = Vorgn_id;
1663: -- Bug 5350197 Added
1664: CURSOR Cur_get_serial_control(Vitem_id NUMBER, Vorgn_id NUMBER) IS
1665: SELECT serial_number_control_code
1666: FROM mtl_system_items
1667: WHERE inventory_item_id = Vitem_id
1668: AND organization_id = Vorgn_id;
1669:
1670: CURSOR Cur_check_revision(Vitem_id NUMBER, Vorgn_id NUMBER, V_revision VARCHAR2) IS

Line 1681: lItem_um mtl_system_items.primary_uom_code%type;

1677: l_ret NUMBER;
1678: lItem_id NUMBER;
1679: l_temp NUMBER;
1680: l_revision NUMBER;
1681: lItem_um mtl_system_items.primary_uom_code%type;
1682: l_serial_control NUMBER; -- Bug 5350197
1683:
1684: --Exceptions
1685: check_buffer_ind_exception EXCEPTION;

Line 1994: FROM mtl_system_items

1990: xReturn OUT NOCOPY VARCHAR2) IS
1991: --Cursor Declaration
1992: CURSOR Cur_get_revision(Vitem_id NUMBER, Vorgn_id NUMBER) IS
1993: SELECT revision_qty_control_code
1994: FROM mtl_system_items
1995: WHERE inventory_item_id = Vitem_id
1996: AND organization_id = Vorgn_id;
1997: CURSOR Cur_check_revision(Vitem_id NUMBER, Vorgn_id NUMBER, V_revision VARCHAR2) IS
1998: SELECT 1

Line 2008: lItem_um mtl_system_items.primary_uom_code%type;

2004: l_ret NUMBER;
2005: lItem_id NUMBER;
2006: l_temp NUMBER;
2007: l_revision NUMBER;
2008: lItem_um mtl_system_items.primary_uom_code%type;
2009: --Exceptions
2010: check_buffer_ind_exception EXCEPTION;
2011: check_line_no_exception EXCEPTION;
2012: check_qty_exception EXCEPTION;

Line 2278: FROM fm_matl_dtl d, mtl_system_items_b i

2274: CURSOR cur_check_expr(p_org_id NUMBER) IS
2275: SELECT 1
2276: FROM SYS.DUAL
2277: WHERE EXISTS (SELECT 1
2278: FROM fm_matl_dtl d, mtl_system_items_b i
2279: WHERE recipe_enabled_flag = 'Y'
2280: AND i.ORGANIZATION_ID = p_org_id
2281: AND d.formula_id = V_formula_id
2282: AND i.inventory_item_id = d.inventory_item_id

Line 2364: FROM fm_matl_dtl d, mtl_system_items_b i

2360: CURSOR cur_check_inactive IS
2361: SELECT 1
2362: FROM SYS.DUAL
2363: WHERE EXISTS (SELECT 1
2364: FROM fm_matl_dtl d, mtl_system_items_b i
2365: WHERE d.formula_id = V_formula_id
2366: AND i.inventory_item_id = d.inventory_item_id
2367: AND i.recipe_enabled_flag = 'N'
2368: AND i.organization_id = d.organization_id); -- Bug # 5040915 Kapil M