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_CATEGORY_SET_VALID_CATS

Line 2190: and (mdsv.validate_flag='Y' and mck.category_id in (select mcsv.category_id from mtl_category_set_valid_cats mcsv where mcsv.category_set_id = mdsv.category_set_id) or mdsv.validate_flag <> 'Y'));

2186: and mck.enabled_flag = 'Y'
2187: and sysdate between nvl(mck.start_date_active, sysdate) and
2188: nvl(mck.end_date_active, sysdate)
2189: and nvl(mck.disable_date, sysdate + 1) > sysdate
2190: and (mdsv.validate_flag='Y' and mck.category_id in (select mcsv.category_id from mtl_category_set_valid_cats mcsv where mcsv.category_set_id = mdsv.category_set_id) or mdsv.validate_flag <> 'Y'));
2191:
2192: -- set item number and revision to null if this is a group
2193: update pon_item_prices_interface p1
2194: set item_number = null,

Line 2230: and (mdsv.validate_flag='Y' and mck.category_id in (select mcsv.category_id from mtl_category_set_valid_cats mcsv where mcsv.category_set_id = mdsv.category_set_id) or mdsv.validate_flag <> 'Y'))));

2226: and mck.enabled_flag = 'Y'
2227: and sysdate between nvl(mck.start_date_active, sysdate) and
2228: nvl(mck.end_date_active, sysdate)
2229: and nvl(mck.disable_date, sysdate + 1) > sysdate
2230: and (mdsv.validate_flag='Y' and mck.category_id in (select mcsv.category_id from mtl_category_set_valid_cats mcsv where mcsv.category_set_id = mdsv.category_set_id) or mdsv.validate_flag <> 'Y'))));
2231:
2232:
2233: -- set inventory item id, the description update flag, and default the description and unit of measure
2234: -- it not entered for inventory items

Line 2462: (SELECT MCSV.CATEGORY_ID FROM MTL_CATEGORY_SET_VALID_CATS MCSV WHERE

2458: MCS.CATEGORY_SET_id=MDCS.CATEGORY_SET_ID AND
2459: MDCS.FUNCTIONAL_AREA_ID=2 AND MCK.STRUCTURE_ID=MCS.STRUCTURE_ID
2460: AND NVL(mck.DISABLE_DATE, SYSDATE + 1) > SYSDATE
2461: AND (MCS.VALIDATE_FLAG='Y' AND mck.CATEGORY_ID IN
2462: (SELECT MCSV.CATEGORY_ID FROM MTL_CATEGORY_SET_VALID_CATS MCSV WHERE
2463: MCSV.CATEGORY_SET_ID=MCS.CATEGORY_SET_ID) OR MCS.VALIDATE_FLAG <> 'Y')
2464: AND MC.CATEGORY_ID = MCK.CATEGORY_ID)
2465: where batch_id = p_batch_id
2466: and category_name <> 'CAT_NON_ENTERED';

Line 2490: (SELECT MCSV.CATEGORY_ID FROM MTL_CATEGORY_SET_VALID_CATS MCSV WHERE

2486: MCS.CATEGORY_SET_id=MDCS.CATEGORY_SET_ID AND
2487: MDCS.FUNCTIONAL_AREA_ID=2 AND MCK.STRUCTURE_ID=MCS.STRUCTURE_ID
2488: AND NVL(mck.DISABLE_DATE, SYSDATE + 1) > SYSDATE
2489: AND (MCS.VALIDATE_FLAG='Y' AND mck.CATEGORY_ID IN
2490: (SELECT MCSV.CATEGORY_ID FROM MTL_CATEGORY_SET_VALID_CATS MCSV WHERE
2491: MCSV.CATEGORY_SET_ID=MCS.CATEGORY_SET_ID) OR MCS.VALIDATE_FLAG <> 'Y')
2492: AND MC.CATEGORY_ID = MCK.CATEGORY_ID)
2493: where batch_id = p_batch_id
2494: and category_name <> 'CAT_NON_ENTERED'