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_NEGOTIATIONS_SV1 dependencies on PO_LINES

Line 430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;

426: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
427: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
428: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
429: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
430: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
431: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
432:
433: --bug5841426
434:

Line 2027: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,

2023: pl.contract_type,
2024: pl.cost_constraint,
2025: pl.clm_idc_type
2026:
2027: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,
2028: financials_system_parameters fsp --
2029: where po_header_id=p_po_header_id and
2030: mum.unit_of_measure (+) = pl.unit_meas_lookup_code and --
2031: --bug #2716412: made pl/msi join an outer join

Line 2096: -- bug 2714549: added paii to join; removed join to po_lines

2092: pll.created_by,
2093: pll.last_update_date,
2094: pll.last_updated_by
2095: from po_line_locations pll,
2096: -- bug 2714549: added paii to join; removed join to po_lines
2097: pon_auc_items_interface paii
2098: where pll.po_header_id = p_po_header_id and
2099: --bug 2714549 start: changed join conditions from po_lines
2100: -- to paii and added auction_header cond

Line 2099: --bug 2714549 start: changed join conditions from po_lines

2095: from po_line_locations pll,
2096: -- bug 2714549: added paii to join; removed join to po_lines
2097: pon_auc_items_interface paii
2098: where pll.po_header_id = p_po_header_id and
2099: --bug 2714549 start: changed join conditions from po_lines
2100: -- to paii and added auction_header cond
2101: -- to ensure unique doc_id/line_id from paii
2102: paii.source_doc_id = p_po_header_id and
2103: paii.source_line_id = pll.po_line_id and

Line 2141: , po_lines_all POL

2137: , PD.last_update_date
2138: , PD.last_updated_by
2139: , PD.last_update_login
2140: FROM po_price_differentials PD
2141: , po_lines_all POL
2142: WHERE PD.entity_type = 'BLANKET LINE'
2143: AND PD.entity_id = POL.po_line_id
2144: AND POL.po_header_id = p_po_header_id;
2145:

Line 2177: , po_lines_all POL

2173: , PD.last_update_date
2174: , PD.last_updated_by
2175: , PD.last_update_login
2176: FROM po_price_differentials PD
2177: , po_lines_all POL
2178: , po_line_locations_all POLL
2179: WHERE PD.entity_type = 'PRICE BREAK'
2180: AND PD.entity_id = POLL.line_location_id
2181: AND POLL.po_line_id = POL.po_line_id

Line 2239: --bug 2714549: replaced join to po_lines

2235: fad.created_by
2236: from fnd_attached_documents fad,
2237: fnd_documents fd,
2238: fnd_documents_tl fdtl,
2239: --bug 2714549: replaced join to po_lines
2240: -- with join to paii.
2241: pon_auc_items_interface paii
2242: where fad.document_id = fd.document_id AND
2243: fd.document_id = fdtl.document_id AND

Line 2245: fad.entity_name = 'PO_LINES' AND

2241: pon_auc_items_interface paii
2242: where fad.document_id = fd.document_id AND
2243: fd.document_id = fdtl.document_id AND
2244: fdtl.language = userenv('LANG') AND
2245: fad.entity_name = 'PO_LINES' AND
2246: --bug 2714549 start: changed join conditions from po_lines
2247: -- to paii and added auction_header cond
2248: -- to ensure unique doc_id/line_id from paii
2249: paii.source_doc_id = p_po_header_id AND

Line 2246: --bug 2714549 start: changed join conditions from po_lines

2242: where fad.document_id = fd.document_id AND
2243: fd.document_id = fdtl.document_id AND
2244: fdtl.language = userenv('LANG') AND
2245: fad.entity_name = 'PO_LINES' AND
2246: --bug 2714549 start: changed join conditions from po_lines
2247: -- to paii and added auction_header cond
2248: -- to ensure unique doc_id/line_id from paii
2249: paii.source_doc_id = p_po_header_id AND
2250: fad.pk1_value = to_char(paii.source_line_id) AND

Line 2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;

2489: x_clm_funded_flag po_requisition_lines_all.clm_funded_flag%TYPE;
2490: x_clm_base_line_num po_requisition_lines_all.clm_base_line_num%TYPE;
2491: x_CONTRACT_TYPE po_requisition_lines_all.CONTRACT_TYPE%TYPE;
2492: x_COST_CONSTRAINT po_requisition_lines_all.COST_CONSTRAINT%TYPE;
2493: x_CLM_IDC_TYPE po_lines_all.CLM_IDC_TYPE%TYPE;
2494: x_req_line_temp_id po_requisition_lines_all.UDA_TEMPLATE_ID%TYPE; --
2495: x_req_in_pool_flag VARCHAR2(1) :=NULL;
2496: x_cancel_flag varchar2(1);
2497: x_closed_code varchar2(25);