DBA Data[Home] [Help]

APPS.POR_NOTIFICATION_PKG dependencies on PO_DOCUMENT_TYPES

Line 40: from PO_DOCUMENT_TYPES

36: where user_name = user and
37: user_orig_system = origSys and user_orig_system_id = origId ))
38: and wn.message_type in
39: ( select distinct WF_CREATEDOC_ITEMTYPE
40: from PO_DOCUMENT_TYPES
41: union
42: select distinct WF_APPROVAL_ITEMTYPE
43: from PO_DOCUMENT_TYPES
44: union

Line 43: from PO_DOCUMENT_TYPES

39: ( select distinct WF_CREATEDOC_ITEMTYPE
40: from PO_DOCUMENT_TYPES
41: union
42: select distinct WF_APPROVAL_ITEMTYPE
43: from PO_DOCUMENT_TYPES
44: union
45: select 'PORCPT' from dual)
46: and wn.status = 'OPEN'
47: and exists( select 1 from WF_NOTIFICATION_ATTRIBUTES NA,