APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_HEADERS_ALL

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