APPS.GR_REG_PRINT_DOC dependencies on FND_DOCUMENT_CATEGORIES

Line 81: FROM FND_DOCUMENT_CATEGORIES_VL

77: AND pk1_value = LocalDeliverydetail.source_line_id )
78: OR (entity_name= 'WSH_DELIVERY_DETAILS'
79: AND pk1_value = LocalDeliverydetail.delivery_detail_id ))
80: AND CATEGORY_ID IN (SELECT category_id
81: FROM FND_DOCUMENT_CATEGORIES_VL
82: WHERE UPPER(user_name) like l_bind_var_msds
83: OR UPPER(user_name) like l_bind_var_safety
84: OR UPPER(user_name) like l_bind_var_hazard)
85: /*

Line 450: FROM FND_DOCUMENT_CATEGORIES

446: fnd_documents d
447: WHERE
448: d.category_id IN
449: (SELECT category_id
450: FROM FND_DOCUMENT_CATEGORIES
451: WHERE ( UPPER(name) like l_bind_var_msds or
452: UPPER(name) like l_bind_var_hazard or
453: UPPER(name) like l_bind_var_safety ) AND
454: UPPER(name) NOT like l_bind_var_msds_rejected