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.CHV_BUILD_SCHEDULES dependencies on MTL_SYSTEM_ITEMS

Line 177: EXISTS (SELECT 'check if planner exists in mtl_system_items'

173: AND nvl(paa.scheduler_id,-1) =
174: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
175: AND (p_planner_code IS NULL
176: OR
177: EXISTS (SELECT 'check if planner exists in mtl_system_items'
178: FROM mtl_system_items msi,mtl_planners mtp
179: WHERE msi.planner_code = p_planner_code
180: AND msi.organization_id = x_organization_id
181: AND mtp.organization_id = x_organization_id

Line 178: FROM mtl_system_items msi,mtl_planners mtp

174: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
175: AND (p_planner_code IS NULL
176: OR
177: EXISTS (SELECT 'check if planner exists in mtl_system_items'
178: FROM mtl_system_items msi,mtl_planners mtp
179: WHERE msi.planner_code = p_planner_code
180: AND msi.organization_id = x_organization_id
181: AND mtp.organization_id = x_organization_id
182: AND mtp.planner_code = p_planner_code

Line 186: EXISTS (SELECT 'check if buyer exists in mtl_system_items'

182: AND mtp.planner_code = p_planner_code
183: AND msi.inventory_item_id = paa.item_id))
184: AND (p_buyer_id IS NULL
185: OR
186: EXISTS (SELECT 'check if buyer exists in mtl_system_items'
187: FROM mtl_system_items msi
188: WHERE msi.inventory_item_id = paa.item_id
189: AND msi.organization_id = x_organization_id
190: AND msi.buyer_id = p_buyer_id));

Line 187: FROM mtl_system_items msi

183: AND msi.inventory_item_id = paa.item_id))
184: AND (p_buyer_id IS NULL
185: OR
186: EXISTS (SELECT 'check if buyer exists in mtl_system_items'
187: FROM mtl_system_items msi
188: WHERE msi.inventory_item_id = paa.item_id
189: AND msi.organization_id = x_organization_id
190: AND msi.buyer_id = p_buyer_id));
191:

Line 252: EXISTS (SELECT 'check if planner exists in mtl_system_items'

248: AND nvl(paa.scheduler_id,-1) =
249: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
250: AND (p_planner_code IS NULL
251: OR
252: EXISTS (SELECT 'check if planner exists in mtl_system_items'
253: FROM mtl_system_items msi,mtl_planners mtp
254: WHERE msi.planner_code = p_planner_code
255: AND msi.inventory_item_id = paa.item_id
256: AND mtp.organization_id = x_organization_id

Line 253: FROM mtl_system_items msi,mtl_planners mtp

249: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
250: AND (p_planner_code IS NULL
251: OR
252: EXISTS (SELECT 'check if planner exists in mtl_system_items'
253: FROM mtl_system_items msi,mtl_planners mtp
254: WHERE msi.planner_code = p_planner_code
255: AND msi.inventory_item_id = paa.item_id
256: AND mtp.organization_id = x_organization_id
257: AND mtp.planner_code = p_planner_code

Line 261: EXISTS (SELECT 'check if buyer exists in mtl_system_items'

257: AND mtp.planner_code = p_planner_code
258: AND msi.organization_id = x_organization_id))
259: AND (p_buyer_id IS NULL
260: OR
261: EXISTS (SELECT 'check if buyer exists in mtl_system_items'
262: FROM mtl_system_items msi
263: WHERE msi.inventory_item_id = paa.item_id
264: AND msi.organization_id = x_organization_id
265: AND msi.buyer_id = p_buyer_id));

Line 262: FROM mtl_system_items msi

258: AND msi.organization_id = x_organization_id))
259: AND (p_buyer_id IS NULL
260: OR
261: EXISTS (SELECT 'check if buyer exists in mtl_system_items'
262: FROM mtl_system_items msi
263: WHERE msi.inventory_item_id = paa.item_id
264: AND msi.organization_id = x_organization_id
265: AND msi.buyer_id = p_buyer_id));
266:

Line 823: FROM mtl_system_items msi

819:
820: IF p_buyer_id IS NOT NULL THEN
821: BEGIN
822: SELECT 'Y' INTO x_dummy
823: FROM mtl_system_items msi
824: WHERE msi.inventory_item_id = p_item_id
825: AND msi.organization_id = x_organization_id
826: AND msi.buyer_id = p_buyer_id;
827: EXCEPTION

Line 852: SELECT description into x_item_desc from mtl_system_items where p_item_id = inventory_item_id and organization_id = x_organization_id;

848: x_vendor_code := 'No Vendor Site';
849: END IF;
850:
851: IF p_item_id is not null THEN
852: SELECT description into x_item_desc from mtl_system_items where p_item_id = inventory_item_id and organization_id = x_organization_id;
853: ELSE
854: x_item_desc := 'No Item Provided ';
855: END IF;
856:

Line 1422: AND exists (select * from mtl_system_items

1418: AND paa.asl_id = paa.asl_id
1419: AND paa.vendor_id = x_vendor_id
1420: AND paa.vendor_site_id = x_vendor_site_id
1421: AND nvl(p_item_id, paa.item_id) = paa.item_id
1422: AND exists (select * from mtl_system_items
1423: where inventory_item_id = paa.item_id
1424: and organization_id = x_organization_id) /* Bug 462403 vpawar */
1425: AND (p_category_set_id is null
1426: OR

Line 1463: EXISTS (SELECT 'check if planner exists in mtl_system_items'

1459: AND nvl(paa.scheduler_id,-1) =
1460: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
1461: AND (p_planner_code IS NULL
1462: OR
1463: EXISTS (SELECT 'check if planner exists in mtl_system_items'
1464: FROM mtl_system_items msi,mtl_planners mtp
1465: WHERE msi.planner_code = p_planner_code
1466: AND msi.inventory_item_id = paa.item_id
1467: AND mtp.organization_id = x_organization_id

Line 1464: FROM mtl_system_items msi,mtl_planners mtp

1460: NVL(p_scheduler_id, nvl(paa.scheduler_id,-1))
1461: AND (p_planner_code IS NULL
1462: OR
1463: EXISTS (SELECT 'check if planner exists in mtl_system_items'
1464: FROM mtl_system_items msi,mtl_planners mtp
1465: WHERE msi.planner_code = p_planner_code
1466: AND msi.inventory_item_id = paa.item_id
1467: AND mtp.organization_id = x_organization_id
1468: AND mtp.planner_code = p_planner_code

Line 1472: EXISTS (SELECT 'check if buyer exists in mtl_system_items'

1468: AND mtp.planner_code = p_planner_code
1469: AND msi.organization_id = x_organization_id))
1470: AND (p_buyer_id IS NULL
1471: OR
1472: EXISTS (SELECT 'check if buyer exists in mtl_system_items'
1473: FROM mtl_system_items msi
1474: WHERE msi.inventory_item_id = paa.item_id
1475: AND msi.organization_id = x_organization_id
1476: AND msi.buyer_id = p_buyer_id));

Line 1473: FROM mtl_system_items msi

1469: AND msi.organization_id = x_organization_id))
1470: AND (p_buyer_id IS NULL
1471: OR
1472: EXISTS (SELECT 'check if buyer exists in mtl_system_items'
1473: FROM mtl_system_items msi
1474: WHERE msi.inventory_item_id = paa.item_id
1475: AND msi.organization_id = x_organization_id
1476: AND msi.buyer_id = p_buyer_id));
1477: /* GROUP BY paa.asl_id,

Line 1690: FROM MTL_system_items

1686: -- Get the new primary unit of measure associated with the item
1687: -- in case the primary unit of measure has changed.
1688: SELECT primary_unit_of_measure
1689: INTO x_primary_unit_of_measure_l
1690: FROM MTL_system_items
1691: WHERE organization_id = x_organization_id
1692: AND inventory_item_id = x_item_id_l;
1693:
1694: ELSIF p_schedule_category = 'REVISION' THEN

Line 1763: -- MTL_SYSTEM_ITEMS.

1759:
1760: IF (p_schedule_category <> 'REBUILD') THEN
1761:
1762: -- Select item_planning_method and primary_unit_of_measure from
1763: -- MTL_SYSTEM_ITEMS.
1764: ---- dbms_output.put_line ('Create_items: select from MTL_SYSTEM_ITEMS');
1765:
1766: x_progress := '040';
1767: -- DEBUG Prio C. Move to main cursor.

Line 1764: ---- dbms_output.put_line ('Create_items: select from MTL_SYSTEM_ITEMS');

1760: IF (p_schedule_category <> 'REBUILD') THEN
1761:
1762: -- Select item_planning_method and primary_unit_of_measure from
1763: -- MTL_SYSTEM_ITEMS.
1764: ---- dbms_output.put_line ('Create_items: select from MTL_SYSTEM_ITEMS');
1765:
1766: x_progress := '040';
1767: -- DEBUG Prio C. Move to main cursor.
1768: /* SELECT decode(p_schedule_category, 'REVISION', x_item_planning_method_l, */

Line 1773: FROM MTL_system_items

1769: SELECT mrp_planning_code,
1770: primary_unit_of_measure
1771: INTO x_item_planning_method_l,
1772: x_primary_unit_of_measure_l
1773: FROM MTL_system_items
1774: WHERE organization_id = x_organization_id
1775: AND inventory_item_id = x_item_id_l;
1776:
1777: ---- dbms_output.put_line('Create_items: Planning Meth'||x_item_planning_method_l);