eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQAPPROVAL_INIT1 dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 7923: from wf_item_activity_statuses ias,

7919:
7920: update wf_notifications set status = 'CLOSED'
7921: where notification_id in (
7922: select ias.notification_id
7923: from wf_item_activity_statuses ias,
7924: wf_notifications ntf
7925: where ias.item_type = itemtype
7926: and ias.item_key = itemkey
7927: and ntf.notification_id = ias.notification_id);

Line 8486: wf_item_activity_statuses wa

8482: begin
8483: select a.notification_id, a.recipient_role
8484: INTO l_nid, l_ntf_role_name
8485: from wf_notifications a,
8486: wf_item_activity_statuses wa
8487: where itemkey=wa.item_key
8488: and itemtype=wa.item_type
8489: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')
8490: and a.notification_id=wa.notification_id and a.status = 'CLOSED';

Line 8501: wf_item_activity_statuses wa

8497: --dbms_output.put_line('For Releases');
8498: select a.notification_id, a.recipient_role
8499: INTO l_nid, l_ntf_role_name
8500: from wf_notifications a,
8501: wf_item_activity_statuses wa
8502: where itemkey=wa.item_key
8503: and itemtype=wa.item_type
8504: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')
8505: and a.notification_id=wa.notification_id and a.status = 'CLOSED';

Line 8681: wf_item_activity_statuses wa

8677: begin
8678: select a.notification_id, a.recipient_role
8679: INTO l_nid, l_ntf_role_name
8680: from wf_notifications a,
8681: wf_item_activity_statuses wa
8682: where itemkey=wa.item_key
8683: and itemtype=wa.item_type
8684: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')
8685: and a.notification_id=wa.notification_id and a.status = 'CLOSED';

Line 8696: wf_item_activity_statuses wa

8692: --dbms_output.put_line('For Releases');
8693: select a.notification_id, a.recipient_role
8694: INTO l_nid, l_ntf_role_name
8695: from wf_notifications a,
8696: wf_item_activity_statuses wa
8697: where itemkey=wa.item_key
8698: and itemtype=wa.item_type
8699: and a.message_name in ('PO_EMAIL_PO_WITH_RESPONSE', 'PO_EMAIL_PO_PDF_WITH_RESPONSE')
8700: and a.notification_id=wa.notification_id and a.status = 'CLOSED';