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 265: - Open cursor PO_HEADERS table to select

261: PROCEDURE NAME: Process_unapprove_pos
262:
263: DESCRIPTION:
264: This procedure does the following:
265: - Open cursor PO_HEADERS table to select
266: Incomplete or Requires_reapproval documents.
267:
268: - For each unapprove document, initiate the
269: PO Approval Reminder workflow notification.

Line 282: FROM PO_HEADERS

278: --
279:
280: CURSOR unapprove_PO IS
281: SELECT PO_Header_ID, Segment1, Type_Lookup_Code, Agent_ID
282: FROM PO_HEADERS
283: WHERE NVL(authorization_status,'INCOMPLETE') IN
284: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
285: -- AND WF_ITEM_TYPE = NULL
286: -- AND WF_ITEM_KEY = NULL

Line 475: PO_HEADERS POH

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
479: -- AND WF_ITEM_KEY = NULL

Line 668: FROM PO_HEADERS poh

664: -- poh.acceptance_required_flag can be Y or D
665: CURSOR PO_acceptance IS
666: SELECT poh.PO_Header_ID, poh.Segment1, poh.Type_Lookup_Code,
667: poh.Agent_ID, NVL(poh.Acceptance_Due_Date, SYSDATE)
668: FROM PO_HEADERS poh
669: WHERE NVL(poh.authorization_status,'INCOMPLETE') = 'APPROVED'
670: AND NVL(poh.acceptance_required_flag,'N') in ('Y','D')
671: AND poh.type_lookup_code in
672: ('STANDARD','PLANNED','BLANKET','CONTRACT')

Line 1013: PO_HEADERS POH

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'
1017: AND NVL(PORH.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 1335: - Open cursor PO_HEADERS table to select

1331: PROCEDURE NAME: Process_rfq_quote
1332:
1333: DESCRIPTION:
1334: This procedure does the following:
1335: - Open cursor PO_HEADERS table to select
1336: RFQ and Quote documents.
1337:
1338: - For each selected document, initiate the
1339: PO Approval Reminder workflow notification.

Line 1375: FROM PO_HEADERS

1371: NVL(RFQ_close_date,SYSDATE + 1),
1372: NVL(End_date,SYSDATE + 1),
1373: decode(End_date, NULL, 0, NVL(Quote_warning_delay,0))
1374: Quote_warning_delay
1375: FROM PO_HEADERS
1376: WHERE NVL(Status_lookup_code,'I') IN ('I','A')
1377: AND type_lookup_code in ('RFQ','QUOTATION');
1378:
1379:

Line 1852: PO_HEADERS_SV4.get_doc_type_lookup_code

1848: --
1849: l_doc_type_name := '';
1850: l_doc_type_lookup_code := '';
1851:
1852: PO_HEADERS_SV4.get_doc_type_lookup_code
1853: (l_doc_type_temp,
1854: l_doc_subtype,
1855: l_doc_type_name,
1856: l_doc_type_lookup_code);

Line 1961: FROM PO_HEADERS

1957: IF l_doc_type = 'PO_ACCEPTANCE' THEN
1958:
1959: SELECT NVL(acceptance_due_date,SYSDATE)
1960: INTO l_acceptance_due_date
1961: FROM PO_HEADERS
1962: WHERE po_header_id = l_doc_header_id;
1963: ELSE
1964:
1965: SELECT NVL(acceptance_due_date, SYSDATE)

Line 2012: FROM PO_HEADERS

2008: l_quote_end_date_active,
2009: l_quote_warning_delay,
2010: l_status_lookup_code,
2011: l_quote_type_lookup_code
2012: FROM PO_HEADERS
2013: WHERE PO_HEADER_ID = l_doc_header_id;
2014:
2015:
2016: l_quote_lookup_code_type := l_doc_type || ' SUBTYPE';

Line 2019: PO_HEADERS_SV4.get_lookup_code_dsp

2015:
2016: l_quote_lookup_code_type := l_doc_type || ' SUBTYPE';
2017: l_quote_type_disp := '';
2018:
2019: PO_HEADERS_SV4.get_lookup_code_dsp
2020: (l_quote_lookup_code_type,
2021: l_quote_type_lookup_code,
2022: l_quote_type_disp);
2023:

Line 2347: l_document_num po_headers_all.segment1%type;

2343: l_user_id NUMBER;
2344: l_progress VARCHAR2(300) := NULL;
2345:
2346: /* Bug 2780033 */
2347: l_document_num po_headers_all.segment1%type;
2348: l_default_method PO_VENDOR_SITES.SUPPLIER_NOTIF_METHOD%TYPE := null;
2349: l_emailaddress po_vendor_sites.email_Address%type := null;
2350: l_faxnum varchar2(30) := null; --Bug 5765243
2351: l_emailflag varchar2(1) := 'N';

Line 2354: l_preparerid po_headers.agent_id%type;

2350: l_faxnum varchar2(30) := null; --Bug 5765243
2351: l_emailflag varchar2(1) := 'N';
2352: l_faxflag varchar2(1) := 'N';
2353: l_printflag varchar2(1) := 'N';
2354: l_preparerid po_headers.agent_id%type;
2355:
2356: Cursor get_user_id is
2357: select user_id
2358: from fnd_user

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

2818: l_doc_type := 'PO';
2819:
2820: select agent_id
2821: into l_agent_id
2822: from po_headers_all /*Bug6632095: using base table instead of view */
2823: where po_header_id = p_DocumentID;
2824: --bug#3709971 modified the structure of item key from
2825: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2826: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

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

2865: l_doc_type := 'PA';
2866:
2867: select agent_id
2868: into l_agent_id
2869: from po_headers_all /*Bug6632095: using base table instead of view */
2870: where po_header_id = p_DocumentID;
2871: --bug#3709971 modified the structure of item key from
2872: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2873: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

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

2935: l_doc_type := 'PO_ACCEPTANCE';
2936:
2937: select type_lookup_code
2938: into l_doc_subtype
2939: from po_headers_all /*Bug6632095: using base table instead of view */
2940: where po_header_id = p_DocumentID;
2941: --bug#3709971 modified the structure of item key from
2942: --doc_type||doc_subtype||doc_num(old structure) to
2943: --doc_type||'-'||doc_subtype||'-'||doc_num

Line 2972: from po_headers_all poh, --

2968: l_doc_type := 'REL_ACCEPTANCE';
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:

Line 3225: , po_headers_all poh

3221: ( SELECT PLL.po_line_id
3222: , SUM(PLL.amount_billed) total_amount_billed
3223: FROM po_line_locations PLL
3224: , po_lines_all POL
3225: , po_headers_all poh
3226: WHERE poh.type_lookup_code = 'STANDARD'
3227: AND poh.po_header_id = POL.po_header_id
3228: AND POL.purchase_basis = 'TEMP LABOR'
3229: AND POL.po_line_id = PLL.po_line_id

Line 3415: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

3411: l_item_exist VARCHAR2(1);
3412: l_item_end_date DATE;
3413: l_requester_user_name WF_USERS.name%TYPE;
3414: l_requester_disp_name WF_USERS.display_name%TYPE;
3415: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
3416: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
3417: l_document_number PO_HEADERS_ALL.segment1%TYPE;
3418: BEGIN
3419: l_item_key := 'PO_LINE_REMINDER-' || p_line_reminder_type || '-'

Line 3417: l_document_number PO_HEADERS_ALL.segment1%TYPE;

3413: l_requester_user_name WF_USERS.name%TYPE;
3414: l_requester_disp_name WF_USERS.display_name%TYPE;
3415: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
3416: l_req_header_id PO_REQUISITION_HEADERS_ALL.requisition_header_id%TYPE;
3417: l_document_number PO_HEADERS_ALL.segment1%TYPE;
3418: BEGIN
3419: l_item_key := 'PO_LINE_REMINDER-' || p_line_reminder_type || '-'
3420: || p_po_line_id;
3421:

Line 3515: po_headers_all POH

3511: POH.segment1
3512: INTO l_po_header_id,
3513: l_document_number
3514: FROM po_lines POL,
3515: po_headers_all POH
3516: WHERE POL.po_line_id = p_po_line_id
3517: AND POL.po_header_id = POH.po_header_id;
3518:
3519: BEGIN