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_KFV

Line 1853: mtl_categories_kfv cat

1849: SET (item_description, category_name) =
1850: (SELECT poj.job_long_description,
1851: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
1852: FROM po_job_associations poj,
1853: mtl_categories_kfv cat
1854: WHERE cat.category_id = poj.category_id AND
1855: poj.job_id = p1.job_id)
1856: WHERE batch_id = p_batch_id AND
1857: purchase_basis = 'TEMP LABOR' AND

Line 1911: mtl_categories_kfv cat

1907: decode(nvl(p1.additional_job_details,'JOB_DETAILS_NONE_ENTERED'),'JOB_DETAILS_NONE_ENTERED',poj.job_long_description, p1.additional_job_details),
1908: cat.category_id,
1909: FND_FLEX_EXT.get_segs('INV', 'MCAT', CAT.STRUCTURE_ID, CAT.CATEGORY_ID)
1910: FROM po_job_associations poj,
1911: mtl_categories_kfv cat
1912: WHERE poj.job_id = p1.job_id
1913: AND cat.category_id = poj.category_id)
1914: WHERE batch_id = p_batch_id AND
1915: purchase_basis = 'TEMP LABOR' AND

Line 1986: mtl_categories_kfv mck

1982: not exists (SELECT '1'
1983: FROM mtl_system_items_kfv msi,
1984: mtl_default_sets_view mdsv,
1985: mtl_item_categories mic,
1986: mtl_categories_kfv mck
1987: WHERE msi.concatenated_segments = p1.item_number and
1988: msi.organization_id = l_inventory_org_id and
1989: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and
1990: msi.purchasing_enabled_flag = 'Y' and

Line 2026: mtl_categories_kfv mck

2022: not exists (select '1'
2023: from mtl_system_items_kfv msi,
2024: mtl_default_sets_view mdsv,
2025: mtl_item_categories mic,
2026: mtl_categories_kfv mck
2027: where msi.concatenated_segments = p1.item_number and
2028: msi.organization_id = l_inventory_org_id and
2029: nvl(msi.outside_operation_flag, 'N') = nvl(p1.outside_operation_flag, 'N') and
2030: msi.purchasing_enabled_flag = 'Y' and

Line 2074: mtl_categories_kfv mck

2070: update pon_item_prices_interface p1
2071: set category_name = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2072: from mtl_default_sets_view mdsv,
2073: mtl_item_categories mic,
2074: mtl_categories_kfv mck
2075: where mdsv.functional_area_id = 2 and
2076: mic.inventory_item_id = p1.item_id and
2077: mic.organization_id = l_inventory_org_id and
2078: mic.category_set_id = mdsv.category_set_id and

Line 2146: MTL_CATEGORIES_KFV mck

2142:
2143: update pon_item_prices_interface p1
2144: set CATEGORY_NAME = (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2145: from
2146: MTL_CATEGORIES_KFV mck
2147: ,PO_LINE_TYPES plt
2148: where
2149: plt.line_type_id = p1.line_type_id
2150: and plt.category_id = mck.category_id)

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

2233: where ((category_name = 'CAT_NONE_ENTERED') or (category_name is null))
2234: AND batch_id = p_batch_id
2235: and group_type <> 'GROUP';
2236:
2237: -- First we do case insensitive to avoid full table scan on MTL_CATEGORIES_KFV
2238: update pon_item_prices_interface p
2239: set category_id = (select Nvl(MAX(MCK.category_id),-1)
2240: FROM (select category_id,
2241: FND_FLEX_EXT.get_segs('INV', 'MCAT', STRUCTURE_ID, CATEGORY_ID) CONCATENATED_SEGMENTS,

Line 2247: from MTL_CATEGORIES_KFV) MCK,

2243: START_DATE_ACTIVE,
2244: END_DATE_ACTIVE,
2245: STRUCTURE_ID,
2246: DISABLE_DATE
2247: from MTL_CATEGORIES_KFV) MCK,
2248: MTL_CATEGORY_SETS MCS,
2249: MTL_DEFAULT_CATEGORY_SETS MDCS,
2250: MTL_CATEGORIES MC
2251: WHERE MCK.CONCATENATED_SEGMENTS = p.category_name

Line 2275: from MTL_CATEGORIES_KFV) MCK,

2271: START_DATE_ACTIVE,
2272: END_DATE_ACTIVE,
2273: STRUCTURE_ID,
2274: DISABLE_DATE
2275: from MTL_CATEGORIES_KFV) MCK,
2276: MTL_CATEGORY_SETS MCS,
2277: MTL_DEFAULT_CATEGORY_SETS MDCS,
2278: MTL_CATEGORIES MC
2279: WHERE UPPER(MCK.CONCATENATED_SEGMENTS) = UPPER(p.category_name)

Line 2309: from mtl_categories_kfv i

2305: AND category_id <> -1;
2306: */
2307: update pon_item_prices_interface p
2308: set category_name = (select Nvl(MAX(FND_FLEX_EXT.get_segs('INV', 'MCAT', i.STRUCTURE_ID, i.CATEGORY_ID)),p.category_name)
2309: from mtl_categories_kfv i
2310: where i.category_id = p.category_id)
2311: where batch_id = p_batch_id
2312: and category_name <> 'CAT_NON_ENTERED'
2313: AND category_id <> -1;

Line 2361: mtl_categories_kfv mck

2357: item_number is not null and
2358: category_name <> (select FND_FLEX_EXT.get_segs('INV', 'MCAT', MCK.STRUCTURE_ID, MCK.CATEGORY_ID) concatenated_segments
2359: from mtl_default_sets_view mdsv,
2360: mtl_item_categories mic,
2361: mtl_categories_kfv mck
2362: where mdsv.functional_area_id = 2 and
2363: mic.inventory_item_id = p1.item_id and
2364: mic.organization_id = l_inventory_org_id and
2365: mic.category_set_id = mdsv.category_set_id and