APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_LINES_ALL

Line 1554: po_lines_all PL

1550: l_old_price_tbl,
1551: l_new_line_flag_tbl
1552: FROM po_headers_all PH,
1553: po_lines_draft_all PLD,
1554: po_lines_all PL
1555: WHERE PLD.draft_id = p_draft_id
1556: AND NVL(PLD.delete_flag, 'N') = 'N'
1557: AND PLD.change_accepted_flag IS NULL
1558: AND PLD.po_line_id = PL.po_line_id(+)

Line 1752: FROM po_lines_all PL

1748: AND PLD.change_accepted_flag IS NULL
1749: AND PLD.delete_flag = 'Y'
1750: AND NOT EXISTS
1751: ( SELECT 1
1752: FROM po_lines_all PL
1753: WHERE PLD.po_line_id = PL.po_line_id);
1754:
1755: d_position := 10;
1756:

Line 1871: FROM po_lines_all PL

1867: AND PLD.change_accepted_flag IS NULL
1868: AND NVL(PLD.delete_flag, 'N') <> 'Y'
1869: AND EXISTS
1870: ( SELECT 1
1871: FROM po_lines_all PL
1872: WHERE PLD.po_line_id = PL.po_line_id
1873: AND DECODE (PLD.line_num,
1874: PL.line_num, 'Y', 'N') = 'Y'
1875: AND DECODE (PLD.line_type_id,