APPS.PO_VAL_LINES2 dependencies on MTL_CATEGORIES

Line 1700: FROM mtl_item_categories mic, mtl_categories mcs

1696: AND p_item_id_tbl(i) IS NOT NULL
1697: AND p_category_id_tbl(i) IS NOT NULL
1698: AND NOT EXISTS(
1699: SELECT 1
1700: FROM mtl_item_categories mic, mtl_categories mcs
1701: WHERE mic.category_id = mcs.category_id
1702: AND mic.category_set_id = x_category_set_id
1703: AND mic.category_id = p_category_id_tbl(i)
1704: AND mic.inventory_item_id = p_item_id_tbl(i)

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 4093: x_category Mtl_Categories_Kfv.Concatenated_Segments%type; --14050066

4089: x_structure_id NUMBER;
4090: x_resp_id NUMBER;
4091: x_resp_appl_id NUMBER;
4092: x_user_id NUMBER;
4093: x_category Mtl_Categories_Kfv.Concatenated_Segments%type; --14050066
4094:
4095: BEGIN
4096:
4097: IF PO_LOG.d_proc THEN

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 4144: From Mtl_Categories_Kfv Mck

4140: -- both validate_ccid and validate_segs
4141: IF (v_category) THEN
4142: Select Mck.Concatenated_Segments
4143: into x_category
4144: From Mtl_Categories_Kfv Mck
4145: where mck.category_id = p_category_id_tbl(i);
4146:
4147: v_category := fnd_flex_keyval.validate_segs('CHECK_SEGMENTS',
4148: 'INV',

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: