APPS.PO_COPYDOC_SUB dependencies on MTL_DEFAULT_SETS_VIEW

Line 1061: MTL_DEFAULT_SETS_VIEW MDSV

1057: BEGIN
1058: SELECT MIC.category_id
1059: INTO x_category_id
1060: FROM MTL_ITEM_CATEGORIES MIC,
1061: MTL_DEFAULT_SETS_VIEW MDSV
1062: WHERE MIC.inventory_item_id = x_item_id
1063: AND MIC.organization_id = x_inv_org_id
1064: AND MIC.category_set_id = MDSV.category_set_id
1065: AND MDSV.functional_area_id = 2;

Line 1101: MTL_DEFAULT_SETS_VIEW MDSV

1097: BEGIN
1098: SELECT distinct 'Y'
1099: INTO x_valid_flag
1100: FROM MTL_ITEM_CATEGORIES MIC,
1101: MTL_DEFAULT_SETS_VIEW MDSV
1102: WHERE MIC.category_id = x_category_id
1103: AND MIC.inventory_item_id = x_item_id
1104: AND MIC.organization_id = x_inv_org_id
1105: AND MIC.category_set_id = MDSV.category_set_id

Line 1155: MTL_DEFAULT_SETS_VIEW MDSV

1151:
1152: SELECT distinct 'Y'
1153: INTO x_valid_flag
1154: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
1155: MTL_DEFAULT_SETS_VIEW MDSV
1156: WHERE MCSVC.category_id = x_category_id
1157: AND MCSVC.category_set_id = MDSV.category_set_id
1158: AND MDSV.functional_area_id = 2;
1159: */

Line 1165: FROM MTL_DEFAULT_SETS_VIEW MDSV

1161: select validate_flag,
1162: category_set_id
1163: INTO l_validate_flag,
1164: l_category_set_id
1165: FROM MTL_DEFAULT_SETS_VIEW MDSV
1166: where MDSV.functional_area_id = 2;
1167: Exception
1168: when others then
1169: NULL;