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 156: l_item_id mtl_system_items_kfv.inventory_item_id%TYPE := 0;

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

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

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

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

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

Line 163: FROM mtl_system_items_kfv

159:
160:
161: CURSOR get_id IS
162: SELECT inventory_item_id, primary_uom_code, enabled_flag
163: FROM mtl_system_items_kfv
164: WHERE concatenated_segments = pitem_no
165: AND organization_id = porganization_id;
166:
167: CURSOR get_it_id IS

Line 169: FROM mtl_system_items

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

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

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

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

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

Line 278: FROM mtl_system_items_kfv

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

Line 750: litem_id mtl_system_items.inventory_item_id%TYPE;

746: xTable_out OUT NOCOPY formula_table_out,
747: xReturn OUT NOCOPY VARCHAR2) IS
748:
749: /* Local variables */
750: litem_id mtl_system_items.inventory_item_id%TYPE;
751: litem_um mtl_system_items.primary_uom_code%TYPE;
752: l_return_code NUMBER ;
753: X_count NUMBER := 1;
754:

Line 751: litem_um mtl_system_items.primary_uom_code%TYPE;

747: xReturn OUT NOCOPY VARCHAR2) IS
748:
749: /* Local variables */
750: litem_id mtl_system_items.inventory_item_id%TYPE;
751: litem_um mtl_system_items.primary_uom_code%TYPE;
752: l_return_code NUMBER ;
753: X_count NUMBER := 1;
754:
755: l_formula_id NUMBER;

Line 1509: FROM mtl_system_items

1505: xReturn OUT NOCOPY VARCHAR2) IS
1506: --Cursor Declaration
1507: CURSOR Cur_get_revision (Vitem_id NUMBER, Vorgn_id NUMBER) IS
1508: SELECT revision_qty_control_code
1509: FROM mtl_system_items
1510: WHERE inventory_item_id = Vitem_id
1511: AND organization_id = Vorgn_id;
1512: -- Bug 5350197 Added
1513: CURSOR Cur_get_serial_control (Vitem_id NUMBER, Vorgn_id NUMBER) IS

Line 1515: FROM mtl_system_items

1511: AND organization_id = Vorgn_id;
1512: -- Bug 5350197 Added
1513: CURSOR Cur_get_serial_control (Vitem_id NUMBER, Vorgn_id NUMBER) IS
1514: SELECT serial_number_control_code
1515: FROM mtl_system_items
1516: WHERE inventory_item_id = Vitem_id
1517: AND organization_id = Vorgn_id;
1518:
1519: CURSOR Cur_check_revision (Vitem_id NUMBER, Vorgn_id NUMBER, V_revision VARCHAR2) IS

Line 1530: lItem_um mtl_system_items.primary_uom_code%type;

1526: l_ret NUMBER;
1527: lItem_id NUMBER;
1528: l_temp NUMBER;
1529: l_revision NUMBER;
1530: lItem_um mtl_system_items.primary_uom_code%type;
1531: l_serial_control NUMBER; -- Bug 5350197
1532:
1533: --Exceptions
1534: check_buffer_ind_exception EXCEPTION;

Line 1836: FROM mtl_system_items

1832: xReturn OUT NOCOPY VARCHAR2) IS
1833: --Cursor Declaration
1834: CURSOR Cur_get_revision (Vitem_id NUMBER, Vorgn_id NUMBER) IS
1835: SELECT revision_qty_control_code
1836: FROM mtl_system_items
1837: WHERE inventory_item_id = Vitem_id
1838: AND organization_id = Vorgn_id;
1839: CURSOR Cur_check_revision (Vitem_id NUMBER, Vorgn_id NUMBER, V_revision VARCHAR2) IS
1840: SELECT 1

Line 1850: lItem_um mtl_system_items.primary_uom_code%type;

1846: l_ret NUMBER;
1847: lItem_id NUMBER;
1848: l_temp NUMBER;
1849: l_revision NUMBER;
1850: lItem_um mtl_system_items.primary_uom_code%type;
1851: --Exceptions
1852: check_buffer_ind_exception EXCEPTION;
1853: check_line_no_exception EXCEPTION;
1854: check_qty_exception EXCEPTION;

Line 2117: mtl_system_items_b i

2113: SELECT 1
2114: FROM SYS.DUAL
2115: WHERE EXISTS (SELECT 1
2116: FROM fm_matl_dtl d,
2117: mtl_system_items_b i
2118: WHERE recipe_enabled_flag ='Y'
2119: AND i.ORGANIZATION_ID = p_org_id
2120: AND d.formula_id = V_formula_id
2121: AND i.inventory_item_id = d.inventory_item_id

Line 2201: mtl_system_items_b i

2197: CURSOR cur_check_inactive IS
2198: SELECT 1
2199: FROM SYS.DUAL
2200: WHERE EXISTS (SELECT 1 FROM fm_matl_dtl d,
2201: mtl_system_items_b i
2202: WHERE d.formula_id = V_formula_id
2203: AND i.inventory_item_id = d.inventory_item_id
2204: AND i.recipe_enabled_flag = 'N'
2205: AND i.organization_id = d.organization_id); -- Bug # 5040915 Kapil M