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 250: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,

246: poll.price_override, nvl(poll.need_by_date,sysdate),
247: poh.po_header_id,
248: poh.authorization_status, poh.revision_num,
249: poha.revision_num
250: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
251: po_headers_archive_all poha,financials_system_params_all fsp
252: where pol.from_line_id = l_po_line_id
253: and poh.po_header_id = pol.po_header_id
254: and poh.org_id = fsp.org_id -- -- Bug 3573266

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

355: poll.price_override, nvl(poll.need_by_date,sysdate),
356: poh.po_header_id,
357: poh.authorization_status, poh.revision_num,
358: poha.revision_num
359: from po_headers_all poh, po_lines_all pol, po_line_locations_all poll,
360: po_headers_archive_all poha, po_document_types_all_b pdt,
361: financials_system_params_all fsp
362: where pol.from_line_id = l_po_line_id
363: and poh.po_header_id = pol.po_header_id

Line 431: FROM po_headers_all poh,

427: poh.po_header_id,
428: poh.authorization_status,
429: poh.revision_num,
430: poha.revision_num
431: FROM po_headers_all poh,
432: po_lines_all pol,
433: po_line_locations_all poll,
434: po_headers_archive_all poha,
435: financials_system_params_all fsp

Line 495: FROM po_headers_all poh,

491: poh.po_header_id,
492: poh.authorization_status,
493: poh.revision_num,
494: poha.revision_num
495: FROM po_headers_all poh,
496: po_lines_all pol,
497: po_line_locations_all poll,
498: po_headers_archive_all poha,
499: po_document_types_all_b pdt,

Line 587: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

583:
584:
585: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
586: l_retroactive_date PO_LINES_ALL.retroactive_date%TYPE;
587: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
588:
589:
590:
591: l_api_version CONSTANT NUMBER := 1.0;

Line 781: 'from po_headers_all poh, ' ||

777: */
778: l_module := g_log_head||l_api_name||'.'||'010'||'.';
779: l_sql_str := 'select poh.po_header_id,pol.po_line_id, pol.retroactive_date, ' ||
780: 'poh.global_agreement_flag ' ||
781: 'from po_headers_all poh, ' ||
782: 'po_lines pol, ' ||
783: 'mtl_system_items msi, ' ||
784: 'financials_system_params_all fsp, ' ; --
785: l_sql_str1 := 'mtl_categories mca ' ||

Line 2169: UPDATE po_headers_all poh

2165: * columns.
2166: */
2167: -- Bug 5168776 Update the Revised Date also
2168: FORALL doc_update_index in 1..g_po_header_id_table.COUNT
2169: UPDATE po_headers_all poh
2170: SET poh.revision_num = decode(poh.revision_num,
2171: l_global_arch_rev_num_table(doc_update_index),
2172: poh.revision_num +1,poh.revision_num),
2173: poh.revised_date = decode(poh.revision_num,

Line 2463: po_headers_all POH

2459: l_uom,
2460: l_in_unit_price,
2461: l_currency_code
2462: FROM po_line_locations_all PLL, po_lines_all POL,
2463: po_headers_all POH
2464: WHERE PLL.line_location_id = p_po_line_location_id
2465: AND POL.po_line_id = PLL.po_line_id
2466: AND POH.po_header_id = POL.po_header_id;
2467:

Line 2569: PO_HEADERS_ALL HDR,

2565: BEGIN
2566: SELECT DISTINCT STL.enhanced_pricing_flag
2567: INTO l_enhanced_pricing_flag
2568: FROM PO_DOC_STYLE_HEADERS STL,
2569: PO_HEADERS_ALL HDR,
2570: PO_LINES_ALL LIN
2571: WHERE LIN.po_line_id = l_po_line_id
2572: AND LIN.po_header_id = HDR.po_header_id
2573: AND HDR.style_id = STL.style_id;

Line 2634: l_consigned_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;

2630: x_online_report_id number;
2631: x_msg_count number;
2632: l_doc_org_id number;
2633: -- Bug 3318625
2634: l_consigned_flag PO_HEADERS_ALL.consigned_consumption_flag%TYPE;
2635: x_text_line po_online_report_text.text_line%TYPE; --Bug9040655
2636: max_sequence_num po_online_report_text.sequence%TYPE; --Bug9040655
2637: begin
2638:

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

2639: l_module := g_log_head||l_api_name||'.'||'000'||'.';
2640: /* Bug 2707350.
2641: * Org context needs to be set for the submission check procedure.
2642: * Get the orig org_id and then for each document that will be sent
2643: * sent for submission check, get the org_id from po_headers_all.
2644: * Set the org context using this org_id and if submission check
2645: * is successful, initiate approval. When all documents are done
2646: * set the original org context.
2647: */

Line 2660: from po_headers_all

2656: select org_id,
2657: NVL(consigned_consumption_flag, 'N') -- Bug 3318625
2658: into l_doc_org_id,
2659: l_consigned_flag -- Bug 3318625
2660: from po_headers_all
2661: where po_header_id = g_po_header_id_table(i);
2662:
2663: -- Bug 3318625 START
2664: IF (g_po_auth_table(i) = 'APPROVED' OR

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

2922: l_forward_to_id number;
2923: l_forward_from_id number;
2924: l_def_approval_path_id number;
2925: l_note varchar2(25);
2926: l_ItemType po_headers_all.WF_ITEM_TYPE%TYPE := null;
2927: l_ItemKey po_headers_all.WF_ITEM_Key%TYPE := null;
2928: l_seq_for_item_key varchar2(6) := null;
2929: l_action_orig_from varchar2(30) := 'RETRO'; --need to findout
2930: l_xmlsetup varchar2(1) := 'N';

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

2923: l_forward_from_id number;
2924: l_def_approval_path_id number;
2925: l_note varchar2(25);
2926: l_ItemType po_headers_all.WF_ITEM_TYPE%TYPE := null;
2927: l_ItemKey po_headers_all.WF_ITEM_Key%TYPE := null;
2928: l_seq_for_item_key varchar2(6) := null;
2929: l_action_orig_from varchar2(30) := 'RETRO'; --need to findout
2930: l_xmlsetup varchar2(1) := 'N';
2931: l_docnum po_headers_all.segment1%type;

Line 2931: l_docnum po_headers_all.segment1%type;

2927: l_ItemKey po_headers_all.WF_ITEM_Key%TYPE := null;
2928: l_seq_for_item_key varchar2(6) := null;
2929: l_action_orig_from varchar2(30) := 'RETRO'; --need to findout
2930: l_xmlsetup varchar2(1) := 'N';
2931: l_docnum po_headers_all.segment1%type;
2932: l_preparer_id po_headers.agent_id%type;
2933: l_default_method PO_VENDOR_SITES.SUPPLIER_NOTIF_METHOD%TYPE := null;
2934: l_email_address po_vendor_sites.email_Address%type := null;
2935: l_fax_number varchar2(30) := null; --Changed as part of Bug 5765243

Line 2962: FROM po_headers_all poh

2958: */
2959: If ((p_doc_type = 'PO') OR (p_doc_type = 'PA')) then
2960: SELECT poh.org_id
2961: into l_org_id
2962: FROM po_headers_all poh
2963: WHERE poh.po_header_id = p_doc_id;
2964: elsif (p_doc_type = 'RELEASE') then
2965: SELECT por.org_id
2966: into l_org_id

Line 3656: po_headers_all poh, --

3652: pod.project_id,
3653: pod.task_id,
3654: pod.accrual_account_id distribute_account_id
3655: FROM po_releases por,
3656: po_headers_all poh, --
3657: po_lines pol,
3658: -- Bug 3393219, Consumption transaction owning org
3659: -- financials_system_parameters fsp,
3660: po_line_locations_all poll, --

Line 4571: po_headers_all poh

4567: poh.org_id,
4568: pll.transaction_flow_header_id -- Bug 3880758
4569: from po_line_locations_all pll,
4570: -- Bug 3541961
4571: po_headers_all poh
4572: where pll.po_line_id = p_po_line_id
4573: -- Bug 3541961
4574: and pll.po_header_id = poh.po_header_id;
4575:

Line 4813: po_headers_all poh

4809: SELECT NVL(poh.consigned_consumption_flag, 'N'),
4810: pll.ship_to_organization_id,
4811: pll.transaction_flow_header_id
4812: FROM po_line_locations_all pll,
4813: po_headers_all poh
4814: WHERE pll.po_line_id = p_po_line_id
4815: AND pll.po_header_id = poh.po_header_id;
4816:
4817: CURSOR REL_SHIPMENTS_CSR IS