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.PON_VALIDATE_ITEM_PRICES_INT dependencies on MTL_CATEGORIES

Line 2043: mtl_categories_kfv cat

2039: SET (item_description, category_name) =
2040: (SELECT poj.job_long_description,
2041: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
2042: FROM po_job_associations poj,
2043: mtl_categories_kfv cat
2044: WHERE cat.category_id = poj.category_id AND
2045: poj.job_id = p1.job_id)
2046: WHERE batch_id = p_batch_id AND
2047: purchase_basis = 'TEMP LABOR' AND

Line 2101: mtl_categories_kfv cat

2097: decode(nvl(p1.additional_job_details,'JOB_DETAILS_NONE_ENTERED'),'JOB_DETAILS_NONE_ENTERED',poj.job_long_description, p1.additional_job_details),
2098: cat.category_id,
2099: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
2100: FROM po_job_associations poj,
2101: mtl_categories_kfv cat
2102: WHERE poj.job_id = p1.job_id
2103: AND cat.category_id = poj.category_id)
2104: WHERE batch_id = p_batch_id AND
2105: purchase_basis = 'TEMP LABOR' AND

Line 2176: mtl_categories_kfv mck

2172: not exists (SELECT '1'
2173: FROM mtl_system_items_kfv msi,
2174: mtl_default_sets_view mdsv,
2175: mtl_item_categories mic,
2176: mtl_categories_kfv mck
2177: WHERE msi.concatenated_segments = p1.item_number and
2178: msi.organization_id = l_inventory_org_id and
2179: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and
2180: msi.purchasing_enabled_flag = 'Y' and

Line 2216: mtl_categories_kfv mck

2212: not exists (select '1'
2213: from mtl_system_items_kfv msi,
2214: mtl_default_sets_view mdsv,
2215: mtl_item_categories mic,
2216: mtl_categories_kfv mck
2217: where msi.concatenated_segments = p1.item_number and
2218: msi.organization_id = l_inventory_org_id and
2219: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and
2220: msi.purchasing_enabled_flag = 'Y' and

Line 2270: mtl_categories_kfv mck

2266: update pon_item_prices_interface p1
2267: set category_name = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2268: from mtl_default_sets_view mdsv,
2269: mtl_item_categories mic,
2270: mtl_categories_kfv mck
2271: where mdsv.functional_area_id = 2 and
2272: mic.inventory_item_id = p1.item_id and
2273: mic.organization_id = l_inventory_org_id and
2274: mic.category_set_id = mdsv.category_set_id and

Line 2342: MTL_CATEGORIES_KFV mck

2338:
2339: update pon_item_prices_interface p1
2340: set CATEGORY_NAME = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2341: from
2342: MTL_CATEGORIES_KFV mck
2343: ,PO_LINE_TYPES plt
2344: where
2345: plt.line_type_id = p1.line_type_id
2346: and plt.category_id = mck.category_id)

Line 2440: -- First we do case insensitive to avoid full table scan on MTL_CATEGORIES_KFV

2436: AND batch_id = p_batch_id
2437: and group_type <> 'GROUP'
2438: AND Nvl(clm_info_flag,'N') <> 'Y';
2439:
2440: -- First we do case insensitive to avoid full table scan on MTL_CATEGORIES_KFV
2441: update pon_item_prices_interface p
2442: set category_id = (select Nvl(MAX(MCK.category_id),-1)
2443: FROM (select category_id,
2444: FND_FLEX_EXT.get_segs('INV', 'MCAT', STRUCTURE_ID, CATEGORY_ID) CONCATENATED_SEGMENTS,

Line 2450: from MTL_CATEGORIES_KFV) MCK,

2446: START_DATE_ACTIVE,
2447: END_DATE_ACTIVE,
2448: STRUCTURE_ID,
2449: DISABLE_DATE
2450: from MTL_CATEGORIES_KFV) MCK,
2451: MTL_CATEGORY_SETS MCS,
2452: MTL_DEFAULT_CATEGORY_SETS MDCS,
2453: MTL_CATEGORIES MC
2454: WHERE MCK.CONCATENATED_SEGMENTS = p.category_name

Line 2453: MTL_CATEGORIES MC

2449: DISABLE_DATE
2450: from MTL_CATEGORIES_KFV) MCK,
2451: MTL_CATEGORY_SETS MCS,
2452: MTL_DEFAULT_CATEGORY_SETS MDCS,
2453: MTL_CATEGORIES MC
2454: WHERE MCK.CONCATENATED_SEGMENTS = p.category_name
2455: AND MCK.ENABLED_FLAG = 'Y'
2456: AND SYSDATE BETWEEN NVL(MCK.START_DATE_ACTIVE, SYSDATE) AND
2457: NVL(MCK.END_DATE_ACTIVE, SYSDATE) AND

Line 2478: from MTL_CATEGORIES_KFV) MCK,

2474: START_DATE_ACTIVE,
2475: END_DATE_ACTIVE,
2476: STRUCTURE_ID,
2477: DISABLE_DATE
2478: from MTL_CATEGORIES_KFV) MCK,
2479: MTL_CATEGORY_SETS MCS,
2480: MTL_DEFAULT_CATEGORY_SETS MDCS,
2481: MTL_CATEGORIES MC
2482: WHERE UPPER(MCK.CONCATENATED_SEGMENTS) = UPPER(p.category_name)

Line 2481: MTL_CATEGORIES MC

2477: DISABLE_DATE
2478: from MTL_CATEGORIES_KFV) MCK,
2479: MTL_CATEGORY_SETS MCS,
2480: MTL_DEFAULT_CATEGORY_SETS MDCS,
2481: MTL_CATEGORIES MC
2482: WHERE UPPER(MCK.CONCATENATED_SEGMENTS) = UPPER(p.category_name)
2483: AND MCK.ENABLED_FLAG = 'Y'
2484: AND SYSDATE BETWEEN NVL(MCK.START_DATE_ACTIVE, SYSDATE) AND
2485: NVL(MCK.END_DATE_ACTIVE, SYSDATE) AND

Line 2512: from mtl_categories_kfv i

2508: AND category_id <> -1;
2509: */
2510: update pon_item_prices_interface p
2511: set category_name = (select Nvl(MAX(FND_FLEX_EXT.get_segs('INV', 'MCAT', i.STRUCTURE_ID, i.CATEGORY_ID)),p.category_name)
2512: from mtl_categories_kfv i
2513: where i.category_id = p.category_id)
2514: where batch_id = p_batch_id
2515: and category_name <> 'CAT_NON_ENTERED'
2516: AND category_id <> -1;

Line 2564: mtl_categories_kfv mck

2560: item_number is not null and
2561: category_name <> (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2562: from mtl_default_sets_view mdsv,
2563: mtl_item_categories mic,
2564: mtl_categories_kfv mck
2565: where mdsv.functional_area_id = 2 and
2566: mic.inventory_item_id = p1.item_id and
2567: mic.organization_id = l_inventory_org_id and
2568: mic.category_set_id = mdsv.category_set_id and