DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on MTL_CATEGORIES_VL

Line 1130: MTL_CATEGORIES_VL MCV

1126:
1127: SELECT distinct 'Y'
1128: INTO x_valid_flag
1129: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
1130: MTL_CATEGORIES_VL MCV
1131: WHERE MCSVC.category_id = x_category_id
1132: AND MCSVC.category_set_id = l_category_set_id
1133: AND MCV.category_id = MCSVC.category_id
1134: AND sysdate < nvl(mcv.disable_date, sysdate+1)

Line 1141: FROM MTL_CATEGORIES_VL MCV

1137: ELSE
1138:
1139: SELECT distinct 'Y'
1140: INTO x_valid_flag
1141: FROM MTL_CATEGORIES_VL MCV
1142: WHERE MCV.category_id = x_category_id
1143: AND sysdate < nvl(mcv.disable_date, sysdate+1)
1144: AND mcv.enabled_flag = 'Y';
1145: