DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on MTL_CATEGORIES_VL

Line 1742: FROM mtl_categories_vl mcs, mtl_category_set_valid_cats mcsvc

1738: AND p_item_id_tbl(i) IS NULL
1739: AND p_category_id_tbl(i) IS NOT NULL
1740: AND NOT EXISTS(
1741: SELECT 'Y'
1742: FROM mtl_categories_vl mcs, mtl_category_set_valid_cats mcsvc
1743: WHERE mcs.category_id = p_category_id_tbl(i)
1744: AND mcs.category_id = mcsvc.category_id
1745: AND mcsvc.category_set_id = x_category_set_id
1746: AND SYSDATE < NVL(mcs.disable_date, SYSDATE + 1)

Line 1783: FROM mtl_categories_vl mcs

1779: AND p_item_id_tbl(i) IS NULL
1780: AND p_category_id_tbl(i) IS NOT NULL
1781: AND NOT EXISTS(
1782: SELECT 1
1783: FROM mtl_categories_vl mcs
1784: WHERE mcs.category_id = p_category_id_tbl(i)
1785: AND SYSDATE < NVL(mcs.disable_date, SYSDATE + 1)
1786: AND mcs.enabled_flag = 'Y');
1787:

Line 4053: 'MTL_CATEGORIES_VL',

4049: FALSE,
4050: x_resp_appl_id,
4051: x_resp_id,
4052: x_user_id,
4053: 'MTL_CATEGORIES_VL',
4054: NULL,
4055: 'APPL=PO;NAME=PO_RI_INVALID_CATEGORY_ID') ;
4056: IF (validateSegments) THEN
4057: x_results := 'Y';

Line 4138: 'MTL_CATEGORIES_VL' );

4134: NULL,
4135: x_resp_appl_id,
4136: x_resp_id ,
4137: x_user_id,
4138: 'MTL_CATEGORIES_VL' );
4139: -- 14050066: Valid category should pass through
4140: -- both validate_ccid and validate_segs
4141: IF (v_category) THEN
4142: Select Mck.Concatenated_Segments

Line 4164: 'MTL_CATEGORIES_VL',

4160: FALSE,
4161: x_resp_appl_id,
4162: x_resp_id,
4163: x_user_id,
4164: 'MTL_CATEGORIES_VL',
4165: NULL,
4166: 'APPL=PO;NAME=PO_RI_INVALID_CATEGORY_ID') ;
4167: END IF;
4168: