DBA Data[Home] [Help]

APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_RELEASES_ALL

Line 474: FROM PO_RELEASES_ALL PORH, --

470:
471: CURSOR unapprove_REL IS
472: SELECT PORH.PO_release_ID, POH.Segment1, PORH.release_num,
473: POH.Type_Lookup_Code, PORH.Agent_ID
474: FROM PO_RELEASES_ALL PORH, --
475: PO_HEADERS POH
476: WHERE NVL(PORH.authorization_status,'INCOMPLETE') IN
477: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
478: -- AND WF_ITEM_TYPE = NULL

Line 1012: FROM PO_RELEASES_ALL PORH, --

1008: CURSOR REL_acceptance IS
1009: SELECT PORH.PO_release_ID, POH.Segment1, PORH.release_num,
1010: POH.Type_Lookup_Code, PORH.Agent_ID,
1011: NVL(PORH.Acceptance_Due_Date, SYSDATE)
1012: FROM PO_RELEASES_ALL PORH, --
1013: PO_HEADERS POH
1014: WHERE NVL(PORH.authorization_status,'INCOMPLETE') = 'APPROVED'
1015: AND NVL(PORH.acceptance_required_flag,'N')= 'Y'
1016: AND NVL(PORH.cancel_flag,'N') = 'N'

Line 2850: from po_releases_all /*Bug6632095: using base table instead of view */

2846: l_doc_type := 'RELEASE';
2847:
2848: select agent_id
2849: into l_agent_id
2850: from po_releases_all /*Bug6632095: using base table instead of view */
2851: where po_release_id = p_DocumentID;
2852:
2853: --bug#3709971 modified the structure of item key from
2854: --doc_type||doc_subtype||doc_num||agent_id(old structure) to

Line 2917: from po_releases_all /*Bug6632095: using base table instead of view */

2913: l_doc_type := 'RELEASE';
2914:
2915: select agent_id
2916: into l_agent_id
2917: from po_releases_all /*Bug6632095: using base table instead of view */
2918: where po_release_id = p_DocumentID;
2919: --bug#3709971 modified the structure of item key from
2920: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2921: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

Line 2973: po_releases_all por /*Bug6632095: using base table instead of view */

2969:
2970: select poh.type_lookup_code
2971: into l_doc_subtype
2972: from po_headers_all poh, --
2973: po_releases_all por /*Bug6632095: using base table instead of view */
2974: where por.po_header_id = poh.po_header_id and
2975: por.po_release_id = p_DocumentId;
2976:
2977: if (l_doc_subtype = 'PLANNED') then