APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_HEADERS_ALL

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 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