APPS.PO_COPYDOC_SUB dependencies on MTL_DEFAULT_SETS_VIEW

Line 1015: MTL_DEFAULT_SETS_VIEW MDSV

1011: BEGIN
1012: SELECT MIC.category_id
1013: INTO x_category_id
1014: FROM MTL_ITEM_CATEGORIES MIC,
1015: MTL_DEFAULT_SETS_VIEW MDSV
1016: WHERE MIC.inventory_item_id = x_item_id
1017: AND MIC.organization_id = x_inv_org_id
1018: AND MIC.category_set_id = MDSV.category_set_id
1019: AND MDSV.functional_area_id = 2;

Line 1055: MTL_DEFAULT_SETS_VIEW MDSV

1051: BEGIN
1052: SELECT distinct 'Y'
1053: INTO x_valid_flag
1054: FROM MTL_ITEM_CATEGORIES MIC,
1055: MTL_DEFAULT_SETS_VIEW MDSV
1056: WHERE MIC.category_id = x_category_id
1057: AND MIC.inventory_item_id = x_item_id
1058: AND MIC.organization_id = x_inv_org_id
1059: AND MIC.category_set_id = MDSV.category_set_id

Line 1108: MTL_DEFAULT_SETS_VIEW MDSV

1104:
1105: SELECT distinct 'Y'
1106: INTO x_valid_flag
1107: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
1108: MTL_DEFAULT_SETS_VIEW MDSV
1109: WHERE MCSVC.category_id = x_category_id
1110: AND MCSVC.category_set_id = MDSV.category_set_id
1111: AND MDSV.functional_area_id = 2;
1112: */

Line 1118: FROM MTL_DEFAULT_SETS_VIEW MDSV

1114: select validate_flag,
1115: category_set_id
1116: INTO l_validate_flag,
1117: l_category_set_id
1118: FROM MTL_DEFAULT_SETS_VIEW MDSV
1119: where MDSV.functional_area_id = 2;
1120: Exception
1121: when others then
1122: NULL;