APPS.PO_LINES_DRAFT_PVT dependencies on PO_LINES_ALL

Line 273: po_lines_all pl

269: SELECT 'Y'
270: INTO l_clm_document
271: FROM po_headers_all h,
272: po_doc_style_headers pdsh,
273: po_lines_all pl
274: WHERE h.style_id = pdsh.style_id
275: AND h.po_header_id = pl.po_header_id
276: AND pl.po_line_id = l_delete_list(1)
277: AND NVL(pdsh.clm_flag,'N') = 'Y'

Line 343: FROM po_lines_all

339: IF (l_clm_document <> 'Y') THEN
340:
341: SELECT clm_info_flag
342: INTO l_info_flag
343: FROM po_lines_all
344: WHERE po_line_id = l_delete_list(i) ;
345:
346: d_position := 40;
347: IF (PO_LOG.d_stmt) THEN

Line 445: FROM po_lines_all POL,

441: BULK COLLECT
442: INTO l_po_line_id_tbl,
443: l_price_break_lookup_code_tbl,
444: l_update_retro_date_flag_tbl
445: FROM po_lines_all POL,
446: po_lines_draft_all POLD
447: WHERE POLD.draft_id = p_draft_info.draft_id
448: AND POLD.po_line_id = POL.po_line_Id
449: AND NVL(POLD.delete_flag, 'N') = 'N'

Line 549: po_lines_all PL

545: INTO l_id_list,
546: l_del_flag_list,
547: l_txn_exists_list
548: FROM po_lines_draft_all PLD,
549: po_lines_all PL
550: WHERE PLD.draft_id = p_draft_info.draft_id
551: AND NVL(PLD.change_accepted_flag, 'Y') = 'Y'
552: AND PLD.po_line_id = PL.po_line_id(+);
553: