APPS.PO_DIFF_SUMMARY_PKG dependencies on PO_LINES_ALL

Line 1528: po_lines_all PL

1524: l_old_price_tbl,
1525: l_new_line_flag_tbl
1526: FROM po_headers_all PH,
1527: po_lines_draft_all PLD,
1528: po_lines_all PL
1529: WHERE PLD.draft_id = p_draft_id
1530: AND NVL(PLD.delete_flag, 'N') = 'N'
1531: AND PLD.change_accepted_flag IS NULL
1532: AND PLD.po_line_id = PL.po_line_id(+)

Line 1726: FROM po_lines_all PL

1722: AND PLD.change_accepted_flag IS NULL
1723: AND PLD.delete_flag = 'Y'
1724: AND NOT EXISTS
1725: ( SELECT 1
1726: FROM po_lines_all PL
1727: WHERE PLD.po_line_id = PL.po_line_id);
1728:
1729: d_position := 10;
1730:

Line 1845: FROM po_lines_all PL

1841: AND PLD.change_accepted_flag IS NULL
1842: AND NVL(PLD.delete_flag, 'N') <> 'Y'
1843: AND EXISTS
1844: ( SELECT 1
1845: FROM po_lines_all PL
1846: WHERE PLD.po_line_id = PL.po_line_id
1847: AND DECODE (PLD.line_num,
1848: PL.line_num, 'Y', 'N') = 'Y'
1849: AND DECODE (PLD.line_type_id,