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.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_CATEGORIES

Line 2223: Insert into mtl_item_categories

2219: WriteToLog('Inserted rows into mtl_descr_element_values:: '||sql%rowcount,2);
2220:
2221:
2222: /*--------------------------------------+
2223: Insert into mtl_item_categories
2224: Do not insert into CTO category if passed
2225: +--------------------------------------*/
2226: lStmtNumber := 120;
2227:

Line 2240: insert into MTL_ITEM_CATEGORIES

2236:
2237: -- bug 13362916
2238: -- Modified for performance
2239: --
2240: insert into MTL_ITEM_CATEGORIES
2241: (inventory_item_id,
2242: category_set_id,
2243: category_id,
2244: last_update_date,

Line 2272: mtl_item_categories ic,

2268: NULL, -- program_id
2269: SYSDATE, -- program_update_date
2270: ic.organization_id
2271: from
2272: mtl_item_categories ic,
2273: bom_cto_src_orgs bcso,
2274: bom_cto_order_lines_upg bcolu
2275: where bcolu.config_item_id is not null
2276: and bcolu.status = 'BCSO'

Line 2284: from MTL_ITEM_CATEGORIES ic1

2280: and bcso.line_id = bcolu.line_id
2281: and CTO_CUSTOM_CATEGORY_PK.Copy_Category (ic.category_set_id , ic.organization_id) = 1
2282: and NOT EXISTS
2283: (select /*+ NO_UNNEST PUSH_SUBQ */ NULL
2284: from MTL_ITEM_CATEGORIES ic1
2285: where ic1.inventory_item_id = bcolu.config_item_id
2286: and ic1.organization_id = bcso.organization_id
2287: and ic1.category_set_id = ic.category_set_id
2288: and rownum = 1 -- bug 13876670

Line 2291: WriteToLog('Inserted rows into mtl_item_categories:: '||sql%rowcount,2);

2287: and ic1.category_set_id = ic.category_set_id
2288: and rownum = 1 -- bug 13876670
2289: );
2290:
2291: WriteToLog('Inserted rows into mtl_item_categories:: '||sql%rowcount,2);
2292: lStmtNumber := 124;
2293:
2294: --
2295: -- bug 13362916

Line 2298: insert into MTL_ITEM_CATEGORIES

2294: --
2295: -- bug 13362916
2296: -- modified hints
2297: --
2298: insert into MTL_ITEM_CATEGORIES
2299: (inventory_item_id,
2300: category_set_id,
2301: category_id,
2302: last_update_date,

Line 2330: mtl_item_categories ic,

2326: NULL, -- program_id
2327: SYSDATE, -- program_update_date
2328: ic.organization_id
2329: from
2330: mtl_item_categories ic,
2331: mtl_category_sets_b mcsb,
2332: mtl_default_category_sets mdcs,
2333: bom_cto_src_orgs bcso,
2334: bom_cto_order_lines_upg bcolu

Line 2345: from MTL_ITEM_CATEGORIES

2341: and mcsb.category_set_id = mdcs.category_set_id
2342: and mdcs.functional_area_id = 2
2343: and NOT EXISTS
2344: ( select /*+ NO_UNNEST PUSH_SUBQ */ NULL
2345: from MTL_ITEM_CATEGORIES
2346: where inventory_item_id = bcolu.config_item_id
2347: and organization_id = bcso.organization_id
2348: and category_set_id = mcsb.category_set_id
2349: and rownum = 1 -- bug 13876670

Line 2352: WriteToLog('Inserted rows into mtl_item_categories for default categories:: '||sql%rowcount,2);

2348: and category_set_id = mcsb.category_set_id
2349: and rownum = 1 -- bug 13876670
2350: );
2351:
2352: WriteToLog('Inserted rows into mtl_item_categories for default categories:: '||sql%rowcount,2);
2353:
2354: ELSE /* p_cat_id is passed */
2355:
2356: lStmtNumber := 126;

Line 2365: insert into MTL_ITEM_CATEGORIES

2361: --
2362: -- bug 13362916
2363: -- modified hints
2364: --
2365: insert into MTL_ITEM_CATEGORIES
2366: (inventory_item_id,
2367: category_set_id,
2368: category_id,
2369: last_update_date,

Line 2397: mtl_item_categories ic,

2393: NULL, -- program_id
2394: SYSDATE, -- program_update_date
2395: ic.organization_id
2396: from
2397: mtl_item_categories ic,
2398: bom_cto_src_orgs bcso,
2399: bom_cto_order_lines_upg bcolu
2400: where bcolu.config_item_id is not null
2401: and bcolu.status = 'BCSO'

Line 2410: from MTL_ITEM_CATEGORIES ic1

2406: and bcso.line_id = bcolu.line_id
2407: and CTO_CUSTOM_CATEGORY_PK.Copy_Category (ic.category_set_id , ic.organization_id) = 1
2408: and NOT EXISTS
2409: (select /*+ NO_UNNEST PUSH_SUBQ */ NULL
2410: from MTL_ITEM_CATEGORIES ic1
2411: where ic1.inventory_item_id = bcolu.config_item_id
2412: and ic1.organization_id = bcso.organization_id
2413: and ic1.category_set_id = ic.category_set_id
2414: and rownum = 1 -- bug 13876670

Line 2417: WriteToLog('Inserted rows into mtl_item_categories:: '||sql%rowcount,2);

2413: and ic1.category_set_id = ic.category_set_id
2414: and rownum = 1 -- bug 13876670
2415: );
2416:
2417: WriteToLog('Inserted rows into mtl_item_categories:: '||sql%rowcount,2);
2418: lStmtNumber := 128;
2419:
2420: --
2421: -- bug 13362916

Line 2424: insert into MTL_ITEM_CATEGORIES

2420: --
2421: -- bug 13362916
2422: -- modified hints
2423: --
2424: insert into MTL_ITEM_CATEGORIES
2425: (inventory_item_id,
2426: category_set_id,
2427: category_id,
2428: last_update_date,

Line 2456: mtl_item_categories ic,

2452: NULL, -- program_id
2453: SYSDATE, -- program_update_date
2454: ic.organization_id
2455: from
2456: mtl_item_categories ic,
2457: mtl_category_sets_b mcsb,
2458: mtl_default_category_sets mdcs,
2459: bom_cto_src_orgs bcso,
2460: bom_cto_order_lines_upg bcolu

Line 2472: from MTL_ITEM_CATEGORIES

2468: and mcsb.category_set_id = mdcs.category_set_id
2469: and mdcs.functional_area_id = 2
2470: and NOT EXISTS
2471: ( select /*+ NO_UNNEST PUSH_SUBQ */ NULL
2472: from MTL_ITEM_CATEGORIES
2473: where inventory_item_id = bcolu.config_item_id
2474: and organization_id = bcso.organization_id
2475: and category_set_id = mcsb.category_set_id
2476: and rownum = 1 -- bug 13876670

Line 2479: WriteToLog('Inserted rows into mtl_item_categories for default categories:: '||sql%rowcount,2);

2475: and category_set_id = mcsb.category_set_id
2476: and rownum = 1 -- bug 13876670
2477: );
2478:
2479: WriteToLog('Inserted rows into mtl_item_categories for default categories:: '||sql%rowcount,2);
2480:
2481: END IF; /* p_cat_id = -99 */
2482:
2483: