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

Line 3360: FROM MTL_CATEGORIES_B_KFV

3356: l_progress := '020';
3357: BEGIN
3358: SELECT concatenated_segments
3359: INTO x_category_name
3360: FROM MTL_CATEGORIES_B_KFV
3361: WHERE category_id = p_category_id;
3362: EXCEPTION
3363: WHEN OTHERS THEN
3364: l_progress := '030';

Line 3365: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from MTL_CATEGORIES_B_KFV: '||SQLERRM); END IF;

3361: WHERE category_id = p_category_id;
3362: EXCEPTION
3363: WHEN OTHERS THEN
3364: l_progress := '030';
3365: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Exception while getting name from MTL_CATEGORIES_B_KFV: '||SQLERRM); END IF;
3366:
3367: x_category_name := p_category_id;
3368: END;
3369: -- ECO bug 5584556: End

Line 3528: l_category_name MTL_CATEGORIES_B_KFV.concatenated_segments%TYPE;

3524:
3525: l_validate_flag MTL_CATEGORY_SETS_V.validate_flag%TYPE;
3526: l_category_set_id MTL_CATEGORY_SETS_V.category_set_id%TYPE;
3527:
3528: l_category_name MTL_CATEGORIES_B_KFV.concatenated_segments%TYPE;
3529:
3530: l_ip_category_name ICX_CAT_CATEGORIES_V.category_name%TYPE;
3531: l_ip_catgeory_found VARCHAR2(1);
3532: BEGIN

Line 3640: MTL_CATEGORIES MCS

3636: AND p_lines_rec.category_id(i) is not null
3637: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3638: AND NOT EXISTS (SELECT 1
3639: FROM MTL_ITEM_CATEGORIES MIC,
3640: MTL_CATEGORIES MCS
3641: WHERE
3642: MIC.category_id = MCS.category_id
3643: AND MIC.category_set_id = l_category_set_id
3644: AND MIC.category_id = p_lines_rec.category_id(i)

Line 3730: FROM MTL_CATEGORIES_VL MCS,

3726: AND p_lines_rec.category_id(i) is not null
3727: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3728: AND NOT EXISTS
3729: (SELECT 'Y'
3730: FROM MTL_CATEGORIES_VL MCS,
3731: MTL_CATEGORY_SET_VALID_CATS MCSVC
3732: WHERE MCS.category_id = p_lines_rec.category_id(i)
3733: AND MCS.category_id = MCSVC.category_id
3734: AND MCSVC.category_set_id = l_category_set_id

Line 3793: -- MTL_CATEGORIES_VL.

3789: ELSE -- IF l_validate_flag <> 'Y' THEN
3790:
3791: l_progress := '140';
3792: -- SQL What: Bulk validate category. Validate category_id against
3793: -- MTL_CATEGORIES_VL.
3794: -- Insert the error rows into GT table.
3795: -- SQL Why : It will be used to mark the record in plsql table as error.
3796: -- SQL Join: category_id
3797: FORALL i IN 1 .. p_lines_rec.item_id.COUNT

Line 3818: FROM MTL_CATEGORIES_VL MCS

3814: AND p_lines_rec.category_id(i) is not null
3815: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3816: AND NOT EXISTS
3817: (SELECT 1
3818: FROM MTL_CATEGORIES_VL MCS
3819: WHERE MCS.category_id = p_lines_rec.category_id(i)
3820: AND sysdate < nvl(MCS.disable_date, sysdate+1)
3821: AND MCS.enabled_flag = 'Y');
3822: