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_RETROACTIVE_PRICING_PVT dependencies on PO_HEADERS_ALL

Line 243: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

239: poll.price_override, nvl(poll.need_by_date,sysdate),
240: poh.po_header_id,
241: poh.authorization_status, poh.revision_num,
242: poha.revision_num
243: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
244: po_headers_archive_all poha,financials_system_params_all fsp
245: where pol.from_line_id = l_po_line_id
246: and poh.po_header_id = pol.po_header_id
247: and poh.org_id = fsp.org_id -- -- Bug 3573266

Line 340: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

336: poll.price_override, nvl(poll.need_by_date,sysdate),
337: poh.po_header_id,
338: poh.authorization_status, poh.revision_num,
339: poha.revision_num
340: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
341: po_headers_archive_all poha, po_document_types_all_b pdt,
342: financials_system_params_all fsp
343: where pol.from_line_id = l_po_line_id
344: and poh.po_header_id = pol.po_header_id

Line 406: FROM po_headers_all poh,

402: poh.po_header_id,
403: poh.authorization_status,
404: poh.revision_num,
405: poha.revision_num
406: FROM po_headers_all poh,
407: po_lines_all pol,
408: po_line_locations_all poll,
409: po_headers_archive_all poha,
410: financials_system_params_all fsp

Line 470: FROM po_headers_all poh,

466: poh.po_header_id,
467: poh.authorization_status,
468: poh.revision_num,
469: poha.revision_num
470: FROM po_headers_all poh,
471: po_lines_all pol,
472: po_line_locations_all poll,
473: po_headers_archive_all poha,
474: po_document_types_all_b pdt,

Line 562: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

558:
559:
560: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
561: l_retroactive_date PO_LINES_ALL.retroactive_date%TYPE;
562: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
563:
564:
565:
566: l_api_version CONSTANT NUMBER := 1.0;

Line 755: 'from po_headers_all poh, ' ||

751: */
752: l_module := g_log_head||l_api_name||'.'||'010'||'.';
753: l_sql_str := 'select poh.po_header_id,pol.po_line_id, pol.retroactive_date, ' ||
754: 'poh.global_agreement_flag ' ||
755: 'from po_headers_all poh, ' ||
756: 'po_lines pol, ' ||
757: 'mtl_system_items msi, ' ||
758: 'financials_system_params_all fsp, ' ; --
759: l_sql_str1 := 'mtl_categories mca ' ||

Line 2140: UPDATE po_headers_all poh

2136: * columns.
2137: */
2138: -- Bug 5168776 Update the Revised Date also
2139: FORALL doc_update_index in 1..g_po_header_id_table.COUNT
2140: UPDATE po_headers_all poh
2141: SET poh.revision_num = decode(poh.revision_num,
2142: l_global_arch_rev_num_table(doc_update_index),
2143: poh.revision_num +1,poh.revision_num),
2144: poh.revised_date = decode(poh.revision_num,

Line 2436: po_headers_all POH

2432: l_uom,
2433: l_in_unit_price,
2434: l_currency_code
2435: FROM po_line_locations_all PLL, po_lines_all POL,
2436: po_headers_all POH
2437: WHERE PLL.line_location_id = p_po_line_location_id
2438: AND POL.po_line_id = PLL.po_line_id
2439: AND POH.po_header_id = POL.po_header_id;
2440:

Line 2566: l_consigned_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;

2562: x_online_report_id number;
2563: x_msg_count number;
2564: l_doc_org_id number;
2565: -- Bug 3318625
2566: l_consigned_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
2567: begin
2568:
2569: l_module := g_log_head||l_api_name||'.'||'000'||'.';
2570: /* Bug 2707350.

Line 2573: * sent for submission check, get the org_id from po_headers_all.

2569: l_module := g_log_head||l_api_name||'.'||'000'||'.';
2570: /* Bug 2707350.
2571: * Org context needs to be set for the submission check procedure.
2572: * Get the orig org_id and then for each document that will be sent
2573: * sent for submission check, get the org_id from po_headers_all.
2574: * Set the org context using this org_id and if submission check
2575: * is successful, initiate approval. When all documents are done
2576: * set the original org context.
2577: */

Line 2590: from po_headers_all

2586: select org_id,
2587: NVL(consigned_consumption_flag, 'N') -- Bug 3318625
2588: into l_doc_org_id,
2589: l_consigned_flag -- Bug 3318625
2590: from po_headers_all
2591: where po_header_id = g_po_header_id_table(i);
2592:
2593: -- Bug 3318625 START
2594: IF (g_po_auth_table(i) = 'APPROVED' OR

Line 2814: l_ItemType po_headers_all.WF_ITEM_TYPE%TYPE := null;

2810: l_forward_to_id number;
2811: l_forward_from_id number;
2812: l_def_approval_path_id number;
2813: l_note varchar2(25);
2814: l_ItemType po_headers_all.WF_ITEM_TYPE%TYPE := null;
2815: l_ItemKey po_headers_all.WF_ITEM_Key%TYPE := null;
2816: l_seq_for_item_key varchar2(6) := null;
2817: l_action_orig_from varchar2(30) := 'RETRO'; --need to findout
2818: l_xmlsetup varchar2(1) := 'N';

Line 2815: l_ItemKey po_headers_all.WF_ITEM_Key%TYPE := null;

2811: l_forward_from_id number;
2812: l_def_approval_path_id number;
2813: l_note varchar2(25);
2814: l_ItemType po_headers_all.WF_ITEM_TYPE%TYPE := null;
2815: l_ItemKey po_headers_all.WF_ITEM_Key%TYPE := null;
2816: l_seq_for_item_key varchar2(6) := null;
2817: l_action_orig_from varchar2(30) := 'RETRO'; --need to findout
2818: l_xmlsetup varchar2(1) := 'N';
2819: l_docnum po_headers_all.segment1%type;

Line 2819: l_docnum po_headers_all.segment1%type;

2815: l_ItemKey po_headers_all.WF_ITEM_Key%TYPE := null;
2816: l_seq_for_item_key varchar2(6) := null;
2817: l_action_orig_from varchar2(30) := 'RETRO'; --need to findout
2818: l_xmlsetup varchar2(1) := 'N';
2819: l_docnum po_headers_all.segment1%type;
2820: l_preparer_id po_headers.agent_id%type;
2821: l_default_method PO_VENDOR_SITES.SUPPLIER_NOTIF_METHOD%TYPE := null;
2822: l_email_address po_vendor_sites.email_Address%type := null;
2823: l_fax_number varchar2(30) := null; --Changed as part of Bug 5765243

Line 2850: FROM po_headers_all poh

2846: */
2847: If ((p_doc_type = 'PO') OR (p_doc_type = 'PA')) then
2848: SELECT poh.org_id
2849: into l_org_id
2850: FROM po_headers_all poh
2851: WHERE poh.po_header_id = p_doc_id;
2852: elsif (p_doc_type = 'RELEASE') then
2853: SELECT por.org_id
2854: into l_org_id

Line 3535: po_headers_all poh, --

3531: pod.project_id,
3532: pod.task_id,
3533: pod.accrual_account_id distribute_account_id
3534: FROM po_releases por,
3535: po_headers_all poh, --
3536: po_lines pol,
3537: -- Bug 3393219, Consumption transaction owning org
3538: -- financials_system_parameters fsp,
3539: po_line_locations_all poll, --

Line 4450: po_headers_all poh

4446: poh.org_id,
4447: pll.transaction_flow_header_id -- Bug 3880758
4448: from po_line_locations_all pll,
4449: -- Bug 3541961
4450: po_headers_all poh
4451: where pll.po_line_id = p_po_line_id
4452: -- Bug 3541961
4453: and pll.po_header_id = poh.po_header_id;
4454:

Line 4692: po_headers_all poh

4688: SELECT NVL(poh.consigned_consumption_flag, 'N'),
4689: pll.ship_to_organization_id,
4690: pll.transaction_flow_header_id
4691: FROM po_line_locations_all pll,
4692: po_headers_all poh
4693: WHERE pll.po_line_id = p_po_line_id
4694: AND pll.po_header_id = poh.po_header_id;
4695:
4696: CURSOR REL_SHIPMENTS_CSR IS