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 2000: 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'));

1996: and mck.enabled_flag = 'Y'
1997: and sysdate between nvl(mck.start_date_active, sysdate) and
1998: nvl(mck.end_date_active, sysdate)
1999: and nvl(mck.disable_date, sysdate + 1) > sysdate
2000: 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'));
2001:
2002: -- set item number and revision to null if this is a group
2003: update pon_item_prices_interface p1
2004: set item_number = null,

Line 2040: 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'))));

2036: and mck.enabled_flag = 'Y'
2037: and sysdate between nvl(mck.start_date_active, sysdate) and
2038: nvl(mck.end_date_active, sysdate)
2039: and nvl(mck.disable_date, sysdate + 1) > sysdate
2040: 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'))));
2041:
2042:
2043: -- set inventory item id, the description update flag, and default the description and unit of measure
2044: -- it not entered for inventory items

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

2255: MCS.CATEGORY_SET_id=MDCS.CATEGORY_SET_ID AND
2256: MDCS.FUNCTIONAL_AREA_ID=2 AND MCK.STRUCTURE_ID=MCS.STRUCTURE_ID
2257: AND NVL(mck.DISABLE_DATE, SYSDATE + 1) > SYSDATE
2258: AND (MCS.VALIDATE_FLAG='Y' AND mck.CATEGORY_ID IN
2259: (SELECT MCSV.CATEGORY_ID FROM MTL_CATEGORY_SET_VALID_CATS MCSV WHERE
2260: MCSV.CATEGORY_SET_ID=MCS.CATEGORY_SET_ID) OR MCS.VALIDATE_FLAG <> 'Y')
2261: AND MC.CATEGORY_ID = MCK.CATEGORY_ID)
2262: where batch_id = p_batch_id
2263: and category_name <> 'CAT_NON_ENTERED';

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

2283: MCS.CATEGORY_SET_id=MDCS.CATEGORY_SET_ID AND
2284: MDCS.FUNCTIONAL_AREA_ID=2 AND MCK.STRUCTURE_ID=MCS.STRUCTURE_ID
2285: AND NVL(mck.DISABLE_DATE, SYSDATE + 1) > SYSDATE
2286: AND (MCS.VALIDATE_FLAG='Y' AND mck.CATEGORY_ID IN
2287: (SELECT MCSV.CATEGORY_ID FROM MTL_CATEGORY_SET_VALID_CATS MCSV WHERE
2288: MCSV.CATEGORY_SET_ID=MCS.CATEGORY_SET_ID) OR MCS.VALIDATE_FLAG <> 'Y')
2289: AND MC.CATEGORY_ID = MCK.CATEGORY_ID)
2290: where batch_id = p_batch_id
2291: and category_name <> 'CAT_NON_ENTERED'