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_APPROVAL_REMINDER_SV dependencies on PO_HEADERS

Line 277: - Open cursor PO_HEADERS table to select

273: PROCEDURE NAME: Process_unapprove_pos
274:
275: DESCRIPTION:
276: This procedure does the following:
277: - Open cursor PO_HEADERS table to select
278: Incomplete or Requires_reapproval documents.
279:
280: - For each unapprove document, initiate the
281: PO Approval Reminder workflow notification.

Line 294: FROM PO_HEADERS

290: --
291:
292: CURSOR unapprove_PO IS
293: SELECT PO_Header_ID, Segment1, Type_Lookup_Code, Agent_ID
294: FROM PO_HEADERS
295: WHERE NVL(authorization_status,'INCOMPLETE') IN
296: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
297: -- AND WF_ITEM_TYPE = NULL
298: -- AND WF_ITEM_KEY = NULL

Line 487: PO_HEADERS POH

483: CURSOR unapprove_REL IS
484: SELECT PORH.PO_release_ID, POH.Segment1, PORH.release_num,
485: POH.Type_Lookup_Code, PORH.Agent_ID
486: FROM PO_RELEASES_ALL PORH, --
487: PO_HEADERS POH
488: WHERE NVL(PORH.authorization_status,'INCOMPLETE') IN
489: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
490: -- AND WF_ITEM_TYPE = NULL
491: -- AND WF_ITEM_KEY = NULL

Line 680: FROM PO_HEADERS poh

676: -- poh.acceptance_required_flag can be Y or D
677: CURSOR PO_acceptance IS
678: SELECT poh.PO_Header_ID, poh.Segment1, poh.Type_Lookup_Code,
679: poh.Agent_ID, NVL(poh.Acceptance_Due_Date, SYSDATE)
680: FROM PO_HEADERS poh
681: WHERE NVL(poh.authorization_status,'INCOMPLETE') = 'APPROVED'
682: AND NVL(poh.acceptance_required_flag,'N') in ('Y','D')
683: AND poh.type_lookup_code in
684: ('STANDARD','PLANNED','BLANKET','CONTRACT')

Line 1042: PO_HEADERS POH

1038: SELECT PORH.PO_release_ID, POH.Segment1, PORH.release_num,
1039: POH.Type_Lookup_Code, PORH.Agent_ID,
1040: NVL(PORH.Acceptance_Due_Date, SYSDATE)
1041: FROM PO_RELEASES_ALL PORH, --
1042: PO_HEADERS POH
1043: WHERE NVL(PORH.authorization_status,'INCOMPLETE') = 'APPROVED'
1044: AND NVL(PORH.acceptance_required_flag,'N')= 'Y'
1045: AND NVL(PORH.cancel_flag,'N') = 'N'
1046: AND NVL(PORH.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 1364: - Open cursor PO_HEADERS table to select

1360: PROCEDURE NAME: Process_rfq_quote
1361:
1362: DESCRIPTION:
1363: This procedure does the following:
1364: - Open cursor PO_HEADERS table to select
1365: RFQ and Quote documents.
1366:
1367: - For each selected document, initiate the
1368: PO Approval Reminder workflow notification.

Line 1404: FROM PO_HEADERS

1400: NVL(RFQ_close_date,SYSDATE + 1),
1401: NVL(End_date,SYSDATE + 1),
1402: decode(End_date, NULL, 0, NVL(Quote_warning_delay,0))
1403: Quote_warning_delay
1404: FROM PO_HEADERS
1405: WHERE NVL(Status_lookup_code,'I') IN ('I','A','P')
1406: AND type_lookup_code in ('RFQ','QUOTATION');
1407: /*bug 9526568 Added Lookup code value P also to get for printed also*/
1408:

Line 1882: PO_HEADERS_SV4.get_doc_type_lookup_code

1878: --
1879: l_doc_type_name := '';
1880: l_doc_type_lookup_code := '';
1881:
1882: PO_HEADERS_SV4.get_doc_type_lookup_code
1883: (l_doc_type_temp,
1884: l_doc_subtype,
1885: l_doc_type_name,
1886: l_doc_type_lookup_code);

Line 1991: FROM PO_HEADERS

1987: IF l_doc_type = 'PO_ACCEPTANCE' THEN
1988:
1989: SELECT NVL(acceptance_due_date,SYSDATE)
1990: INTO l_acceptance_due_date
1991: FROM PO_HEADERS
1992: WHERE po_header_id = l_doc_header_id;
1993: ELSE
1994:
1995: SELECT NVL(acceptance_due_date, SYSDATE)

Line 2042: FROM PO_HEADERS

2038: l_quote_end_date_active,
2039: l_quote_warning_delay,
2040: l_status_lookup_code,
2041: l_quote_type_lookup_code
2042: FROM PO_HEADERS
2043: WHERE PO_HEADER_ID = l_doc_header_id;
2044: /*bug 9526568 if document printed then also we need to send notification */
2045: IF (NVL(l_status_lookup_code , 'I') = 'P') THEN
2046: l_status_lookup_code := 'A';

Line 2053: PO_HEADERS_SV4.get_lookup_code_dsp

2049:
2050: l_quote_lookup_code_type := l_doc_type || ' SUBTYPE';
2051: l_quote_type_disp := '';
2052:
2053: PO_HEADERS_SV4.get_lookup_code_dsp
2054: (l_quote_lookup_code_type,
2055: l_quote_type_lookup_code,
2056: l_quote_type_disp);
2057:

Line 2381: l_document_num po_headers_all.segment1%type;

2377: l_user_id NUMBER;
2378: l_progress VARCHAR2(300) := NULL;
2379:
2380: /* Bug 2780033 */
2381: l_document_num po_headers_all.segment1%type;
2382: l_default_method PO_VENDOR_SITES.SUPPLIER_NOTIF_METHOD%TYPE := null;
2383: l_emailaddress po_vendor_sites.email_Address%type := null;
2384: l_faxnum varchar2(30) := null; --Bug 5765243
2385: l_emailflag varchar2(1) := 'N';

Line 2388: l_preparerid po_headers.agent_id%type;

2384: l_faxnum varchar2(30) := null; --Bug 5765243
2385: l_emailflag varchar2(1) := 'N';
2386: l_faxflag varchar2(1) := 'N';
2387: l_printflag varchar2(1) := 'N';
2388: l_preparerid po_headers.agent_id%type;
2389:
2390: Cursor get_user_id is
2391: select user_id
2392: from fnd_user

Line 2856: from po_headers_all /Bug6632095: using base table instead of view /

2852: l_doc_type := 'PO';
2853:
2854: select agent_id
2855: into l_agent_id
2856: from po_headers_all /*Bug6632095: using base table instead of view */
2857: where po_header_id = p_DocumentID;
2858: --bug#3709971 modified the structure of item key from
2859: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2860: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

Line 2903: from po_headers_all /Bug6632095: using base table instead of view /

2899: l_doc_type := 'PA';
2900:
2901: select agent_id
2902: into l_agent_id
2903: from po_headers_all /*Bug6632095: using base table instead of view */
2904: where po_header_id = p_DocumentID;
2905: --bug#3709971 modified the structure of item key from
2906: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2907: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

Line 2973: from po_headers_all /Bug6632095: using base table instead of view /

2969: l_doc_type := 'PO_ACCEPTANCE';
2970:
2971: select type_lookup_code
2972: into l_doc_subtype
2973: from po_headers_all /*Bug6632095: using base table instead of view */
2974: where po_header_id = p_DocumentID;
2975: --bug#3709971 modified the structure of item key from
2976: --doc_type||doc_subtype||doc_num(old structure) to
2977: --doc_type||'-'||doc_subtype||'-'||doc_num

Line 3006: from po_headers_all poh, --

3002: l_doc_type := 'REL_ACCEPTANCE';
3003:
3004: select poh.type_lookup_code
3005: into l_doc_subtype
3006: from po_headers_all poh, --
3007: po_releases_all por /*Bug6632095: using base table instead of view */
3008: where por.po_header_id = poh.po_header_id and
3009: por.po_release_id = p_DocumentId;
3010:

Line 3259: , po_headers_all poh

3255: ( SELECT PLL.po_line_id
3256: , SUM(PLL.amount_billed) total_amount_billed
3257: FROM po_line_locations PLL
3258: , po_lines_all POL
3259: , po_headers_all poh
3260: WHERE poh.type_lookup_code = 'STANDARD'
3261: AND poh.po_header_id = POL.po_header_id
3262: AND POL.purchase_basis = 'TEMP LABOR'
3263: AND POL.po_line_id = PLL.po_line_id

Line 3449: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

3445: l_item_exist VARCHAR2(1);
3446: l_item_end_date DATE;
3447: l_requester_user_name WF_USERS.name%TYPE;
3448: l_requester_disp_name WF_USERS.display_name%TYPE;
3449: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
3450: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
3451: l_document_number PO_HEADERS_ALL.segment1%TYPE;
3452: BEGIN
3453: l_item_key := 'PO_LINE_REMINDER-' || p_line_reminder_type || '-'

Line 3451: l_document_number PO_HEADERS_ALL.segment1%TYPE;

3447: l_requester_user_name WF_USERS.name%TYPE;
3448: l_requester_disp_name WF_USERS.display_name%TYPE;
3449: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
3450: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
3451: l_document_number PO_HEADERS_ALL.segment1%TYPE;
3452: BEGIN
3453: l_item_key := 'PO_LINE_REMINDER-' || p_line_reminder_type || '-'
3454: || p_po_line_id;
3455:

Line 3549: po_headers_all POH

3545: POH.segment1
3546: INTO l_po_header_id,
3547: l_document_number
3548: FROM po_lines POL,
3549: po_headers_all POH
3550: WHERE POL.po_line_id = p_po_line_id
3551: AND POL.po_header_id = POH.po_header_id;
3552:
3553: BEGIN