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_AUTO_LINE_PROCESS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 319: FROM po_requisition_lines_all prl

315: SET pli.requisition_line_id = NULL
316: WHERE pli.interface_header_id= PO_AUTOCREATE_PARAMS.x_interface_header_id
317: AND EXISTS
318: (SELECT requisition_line_id
319: FROM po_requisition_lines_all prl
320: WHERE prl.requisition_line_id= pli.requisition_line_id
321: /* Bug : 13695551 : When autocreated from sourcing,
322: * a req line should be allowed to be placed on multiple awards.
323: */

Line 344: FROM po_requisition_lines_all prl --

340: SET pli.requisition_line_id = NULL
341: WHERE pli.interface_header_id= PO_AUTOCREATE_PARAMS.x_interface_header_id
342: AND NOT EXISTS
343: (SELECT requisition_line_id
344: FROM po_requisition_lines_all prl --
345: WHERE prl.requisition_line_id= pli.requisition_line_id
346: );
347:
348:

Line 500: po_requisition_lines_all prl,

496: NVL(pli.contract_type,prl.contract_type) ,
497: NVL(pli.cost_constraint,prl.cost_constraint)
498: FROM po_lines_interface pli,
499: po_headers_interface phi,
500: po_requisition_lines_all prl,
501: po_line_types plt
502: WHERE pli.interface_line_id = pli2.interface_line_id
503: AND pli.interface_header_id = phi.interface_header_id
504: AND phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id

Line 645: po_requisition_lines_all prl --

641: NVL(pli.CLM_BASE_LINE_NUM,prl.CLM_BASE_LINE_NUM)
642: --
643: FROM po_lines_interface pli,
644: po_headers_interface phi,
645: po_requisition_lines_all prl --
646: WHERE pli.interface_line_id = pli2.interface_line_id
647: AND pli.interface_header_id = phi.interface_header_id
648: AND phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
649: AND pli.requisition_line_id = prl.requisition_line_id(+)

Line 880: FROM po_requisition_lines_all prl, --

876: prd.funded_value,
877: prd.partial_funded_flag,
878: prd.quantity_funded, --
879: prd.amount_funded --
880: FROM po_requisition_lines_all prl, --
881: po_req_distributions_all prd, --
882: po_lines_interface pli,
883: po_headers_interface phi
884: WHERE prd.requisition_line_id = prl.requisition_line_id

Line 935: FROM po_requisition_lines_all prl,

931: prl.destination_type_code,
932: prl.destination_organization_id,
933: prl.destination_subinventory,
934: prl.destination_context
935: FROM po_requisition_lines_all prl,
936: po_lines_interface pli --option
937: WHERE pli.interface_header_id = po_autocreate_params.x_interface_header_id
938: AND (( pli.clm_option_indicator = 'O' AND NVL(pli.clm_exercised_flag,'N') = 'N') -- Bug 9960752
939: OR prl.fund_source_not_known = 'Y' )

Line 1642: l_requesting_ou_id po_requisition_lines_all.org_id%TYPE;

1638:
1639: g_calculate_tax_flag VARCHAR2(100);
1640: l_api_name VARCHAR2 (30) := 'derive_and_default_lines';
1641: l_progress VARCHAR2 (3) := '000';
1642: l_requesting_ou_id po_requisition_lines_all.org_id%TYPE;
1643: l_requisition_id_tbl NUMBER;
1644: l_price_break_id NUMBER;
1645: l_cc_unit_price NUMBER;
1646: l_cc_base_unit_price NUMBER;

Line 1656: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;

1652: x_preferred_grade_def MTL_GRADES.GRADE_CODE%TYPE;
1653: l_quantity_temp PO_LINES.QUANTITY%TYPE;
1654: --
1655: l_base_unit_price po_lines.base_unit_price%TYPE := NULL; --
1656: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
1657: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
1658: l_type_lookup_code po_headers_all.type_lookup_code%type; --
1659: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
1660: l_needby_prf VARCHAR2(1);

Line 1675: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;

1671: l_conversion_rate NUMBER :=1;
1672: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type;
1673: l_retainage_rate PO_VENDOR_SITES_ALL.retainage_rate%type;
1674: --
1675: l_job_long_description PO_REQUISITION_LINES_ALL.job_long_description%TYPE;
1676: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
1677: l_return_status VARCHAR2(1);
1678: l_order_type_lookup_code PO_LINE_TYPES_B.order_type_lookup_code%TYPE;
1679: l_purchase_basis1 PO_LINE_TYPES_B.purchase_basis%TYPE;

Line 1866: FROM po_requisition_lines_all prl

1862: BEGIN
1863: l_progress := '051';
1864: SELECT prl.org_id
1865: INTO l_requesting_ou_id
1866: FROM po_requisition_lines_all prl
1867: WHERE prl.requisition_line_id = p_lines.requisition_line_id_tbl (i);
1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: IF g_debug_unexp THEN

Line 2701: FROM po_requisition_lines_all

2697: ELSE
2698: l_progress := '393';
2699: SELECT negotiated_by_preparer_flag
2700: INTO l_negotiated_by_preparer_flag
2701: FROM po_requisition_lines_all
2702: WHERE requisition_line_id=p_lines.requisition_line_id_tbl(i);
2703: END IF;
2704:
2705: ELSE

Line 2711: FROM po_requisition_lines_all

2707: l_progress := '400';
2708:
2709: SELECT negotiated_by_preparer_flag
2710: INTO l_negotiated_by_preparer_flag
2711: FROM po_requisition_lines_all
2712: WHERE requisition_line_id=p_lines.requisition_line_id_tbl(i);
2713:
2714: END IF;
2715:

Line 4732: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

4728: l_progress VARCHAR2(3);
4729: l_precision FND_CURRENCIES.precision%TYPE;
4730: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
4731: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
4732: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4733: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

Line 4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;

4730: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
4731: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
4732: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4733: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
4737: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
4738: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

Line 4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;

4731: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
4732: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4733: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
4737: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
4738: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4739: l_retrun_status VARCHAR2(10);

Line 4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;

4732: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
4733: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
4737: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
4738: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4739: l_retrun_status VARCHAR2(10);
4740:

Line 4737: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;

4733: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE;
4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
4737: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
4738: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4739: l_retrun_status VARCHAR2(10);
4740:
4741: BEGIN

Line 4738: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;

4734: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4735: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
4736: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
4737: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;
4738: l_req_rate PO_REQUISITION_LINES_ALL.rate%TYPE;
4739: l_retrun_status VARCHAR2(10);
4740:
4741: BEGIN
4742:

Line 4777: FROM po_requisition_lines_all PRL

4773: SELECT PRL.currency_code,
4774: NVL(PRL.rate,1)
4775: INTO l_req_currency_code,
4776: l_req_rate
4777: FROM po_requisition_lines_all PRL
4778: WHERE PRL.requisition_line_id = p_requisition_line_id;
4779:
4780: IF ( l_req_currency_code = p_po_currency_code ) THEN
4781: l_progress :='030';

Line 4821: FROM po_requisition_lines_all PRL,

4817: l_req_unit_price ,
4818: l_req_currency_unit_price ,
4819: l_req_amount ,
4820: l_req_currency_amount
4821: FROM po_requisition_lines_all PRL,
4822: financials_system_params_all FSP,
4823: gl_sets_of_books GSB
4824: WHERE PRL.requisition_line_id = p_requisition_line_id
4825: AND NVL(PRL.org_id, -99) = NVL(FSP.org_id, -99)

Line 5049: po_requisition_lines_all prl,

5045: po_clmreq_dist_details_v prd,
5046: (SELECT requisition_line_id, Sum(prd.funds_remaining) AS tot_funds_remaining
5047: FROM po_clmreq_dist_details_v prd
5048: GROUP BY prd.requisition_line_id) req_dist_amt,
5049: po_requisition_lines_all prl,
5050: po_line_types_b plb
5051: WHERE phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
5052: AND pli.interface_header_id = phi.interface_header_id
5053: AND Nvl(pli.orig_from_req_flag, 'N') = 'S'