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 1456: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,

1452: , 'RATE' , PL.committed_amount
1453: , NULL),
1454: PL.purchase_basis, --
1455: pl.ip_category_id --
1456: from po_lines pl, mtl_units_of_measure mum, mtl_system_items_kfv msi,
1457: financials_system_parameters fsp --
1458: where po_header_id=p_po_header_id and
1459: mum.unit_of_measure (+) = pl.unit_meas_lookup_code and --
1460: --bug #2716412: made pl/msi join an outer join

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

1510: pll.created_by,
1511: pll.last_update_date,
1512: pll.last_updated_by
1513: from po_line_locations pll,
1514: -- bug 2714549: added paii to join; removed join to po_lines
1515: pon_auc_items_interface paii
1516: where pll.po_header_id = p_po_header_id and
1517: --bug 2714549 start: changed join conditions from po_lines
1518: -- to paii and added auction_header cond

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

1513: from po_line_locations pll,
1514: -- bug 2714549: added paii to join; removed join to po_lines
1515: pon_auc_items_interface paii
1516: where pll.po_header_id = p_po_header_id and
1517: --bug 2714549 start: changed join conditions from po_lines
1518: -- to paii and added auction_header cond
1519: -- to ensure unique doc_id/line_id from paii
1520: paii.source_doc_id = p_po_header_id and
1521: paii.source_line_id = pll.po_line_id and

Line 1559: , po_lines_all POL

1555: , PD.last_update_date
1556: , PD.last_updated_by
1557: , PD.last_update_login
1558: FROM po_price_differentials PD
1559: , po_lines_all POL
1560: WHERE PD.entity_type = 'BLANKET LINE'
1561: AND PD.entity_id = POL.po_line_id
1562: AND POL.po_header_id = p_po_header_id;
1563:

Line 1595: , po_lines_all POL

1591: , PD.last_update_date
1592: , PD.last_updated_by
1593: , PD.last_update_login
1594: FROM po_price_differentials PD
1595: , po_lines_all POL
1596: , po_line_locations_all POLL
1597: WHERE PD.entity_type = 'PRICE BREAK'
1598: AND PD.entity_id = POLL.line_location_id
1599: AND POLL.po_line_id = POL.po_line_id

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

1653: fad.created_by
1654: from fnd_attached_documents fad,
1655: fnd_documents fd,
1656: fnd_documents_tl fdtl,
1657: --bug 2714549: replaced join to po_lines
1658: -- with join to paii.
1659: pon_auc_items_interface paii
1660: where fad.document_id = fd.document_id AND
1661: fd.document_id = fdtl.document_id AND

Line 1663: fad.entity_name = 'PO_LINES' AND

1659: pon_auc_items_interface paii
1660: where fad.document_id = fd.document_id AND
1661: fd.document_id = fdtl.document_id AND
1662: fdtl.language = userenv('LANG') AND
1663: fad.entity_name = 'PO_LINES' AND
1664: --bug 2714549 start: changed join conditions from po_lines
1665: -- to paii and added auction_header cond
1666: -- to ensure unique doc_id/line_id from paii
1667: paii.source_doc_id = p_po_header_id AND

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

1660: where fad.document_id = fd.document_id AND
1661: fd.document_id = fdtl.document_id AND
1662: fdtl.language = userenv('LANG') AND
1663: fad.entity_name = 'PO_LINES' AND
1664: --bug 2714549 start: changed join conditions from po_lines
1665: -- to paii and added auction_header cond
1666: -- to ensure unique doc_id/line_id from paii
1667: paii.source_doc_id = p_po_header_id AND
1668: fad.pk1_value = paii.source_line_id AND