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_LINES_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 407: po_lines_all pol,

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
411: WHERE pol.Contract_id = l_po_header_id

Line 471: po_lines_all pol,

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,
475: financials_system_params_all fsp

Line 560: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;

556:
557: l_agreement_cur g_agreement_cur_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:

Line 561: l_retroactive_date PO_LINES_ALL.retroactive_date%TYPE;

557: l_agreement_cur g_agreement_cur_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:

Line 794: '(select ''has stdpo'' from po_lines_all pl where '||

790: '((nvl(poh.global_agreement_flag,''N'') = ''Y'') '||
791: ' and ' ||
792: ' (:l_ga_security = ''Y'') '||
793: ' and exists '||
794: '(select ''has stdpo'' from po_lines_all pl where '||
795: ' pl.from_line_id = pol.po_line_id))) ' ;
796: --
797: l_sql_str9 := ' UNION ALL '||
798: 'select poh.po_header_id,NULL, ' ||

Line 810: ' ( SELECT ''has stdpo'' FROM po_lines_all pl '||

806: 'and nvl(poh.authorization_status,''INCOMPLETE'') = ''APPROVED'' ' ||
807: 'and nvl(poh.frozen_flag, ''N'') = ''N'' ' ||
808: 'and nvl(poh.consigned_consumption_flag,''N'') =''N'' '||
809: 'and exists ' ||
810: ' ( SELECT ''has stdpo'' FROM po_lines_all pl '||
811: ' WHERE pl.contract_id = poh.po_header_id ) ';
812: --
813:
814:

Line 1658: UPDATE po_lines_all

1654:
1655: l_module := g_log_head||l_api_name||'.'||'110'||'.';
1656: if l_temp_row_id_table.COUNT <> 0 then
1657: FORALL price_update_index in 1..l_temp_row_id_table.COUNT
1658: UPDATE po_lines_all
1659: SET unit_price =
1660: l_temp_new_price_table(price_update_index),
1661: manual_price_change_flag = 'N', --
1662: last_update_date = g_sysdate,

Line 1684: from po_lines_all pll where

1680: NVL(tax_attribute_update_code,'UPDATE')
1681: --
1682: WHERE poll.po_line_id =
1683: (select pll.po_line_id
1684: from po_lines_all pll where
1685: rowid=l_temp_row_id_table(price_update_index));
1686:
1687: end if; /*l_temp_row_id_table.COUNT <> 0 */
1688: exit when update_line_price%notfound;

Line 2177: from po_lines_all pll where

2173: poll.last_update_date = g_sysdate,
2174: poll.last_updated_by = g_user_id
2175: WHERE poll.po_line_id =
2176: (select pll.po_line_id
2177: from po_lines_all pll where
2178: rowid=l_row_id_table(ship_update_index));
2179:
2180: exception
2181: when l_tax_failure then

Line 2238: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

2234: l_api_name CONSTANT VARCHAR2(50) := 'Process_Price_Change';
2235: l_error_message varchar2(2000);
2236: l_std_po_price_change VARCHAR2(1);
2237: l_retroactive_update VARCHAR2(30) := 'NEVER';
2238: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
2239:
2240: --
2241: l_quantity PO_LINES.quantity%TYPE;
2242: l_ship_to_location_id PO_LINE_LOCATIONS.ship_to_location_id%TYPE;

Line 2435: FROM po_line_locations_all PLL, po_lines_all POL,

2431: l_vendor_site_id,
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;

Line 3270: UPDATE po_lines_all

3266: -- SQL What: Reset retroactive_date for this PO
3267: -- SQL Why : For Standard PO, column po_lines.retroactive_date will
3268: -- be updated if any retroactive pricing changes. Reset it
3269: -- to NULL after processing retroactive pricing.
3270: UPDATE po_lines_all
3271: SET retroactive_date = NULL,
3272: last_update_date = SYSDATE,
3273: last_updated_by = l_user_id
3274: WHERE po_header_id = p_document_id;

Line 3288: FROM po_lines_all pl

3284: -- to the corresponding blanket line retroactive_date after
3285: -- processing retroactive pricing.
3286: UPDATE po_line_locations_all pll
3287: SET retroactive_date = (SELECT pl.retroactive_date
3288: FROM po_lines_all pl
3289: WHERE pl.po_line_id = pll.po_line_id),
3290: last_update_date = SYSDATE,
3291: last_updated_by = l_user_id
3292: WHERE pll.po_release_id = p_document_id;

Line 3468: po_lines_all pol, --

3464: pod.project_id,
3465: pod.task_id,
3466: pod.accrual_account_id distribute_account_id
3467: FROM po_headers poh,
3468: po_lines_all pol, --
3469: -- Bug 3393219, Consumption transaction owning org
3470: -- financials_system_parameters fsp,
3471: po_line_locations_all poll, --
3472: po_line_locations_archive_all polla, --