APPS.PO_LINE_LOCATIONS_DRAFT_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 266: po_line_locations_all pll

262: SELECT 'Y'
263: INTO l_clm_document
264: FROM po_headers_all h,
265: po_doc_style_headers pdsh,
266: po_line_locations_all pll
267: WHERE h.style_id = pdsh.style_id
268: AND h.po_header_id = pll.po_header_id
269: AND pll.line_location_id = l_delete_list(1)
270: AND NVL(pdsh.clm_flag,'N') = 'Y'

Line 384: po_line_locations_all POLL

380: )
381: SELECT l_key,
382: POLLD.po_line_id
383: FROM po_line_locations_draft_all POLLD,
384: po_line_locations_all POLL
385: WHERE POLLD.draft_id = p_draft_info.draft_id
386: AND POLLD.line_location_id = POLL.line_location_id (+)
387: AND NVL(POLLD.change_accepted_flag, 'Y') = 'Y'
388: AND (NVL(POLLD.delete_flag, 'N') = 'Y' OR

Line 402: po_line_locations_all POLL

398: )
399: SELECT l_key,
400: POLLD.po_line_id
401: FROM po_line_locations_draft_all POLLD,
402: po_line_locations_all POLL
403: WHERE POLLD.draft_id = p_draft_info.draft_id
404: AND POLLD.line_location_id = POLL.line_location_id
405: AND NVL(POLLD.change_accepted_flag, 'Y') = 'Y'
406: AND NVL(POLLD.delete_flag, 'N') = 'N'

Line 529: po_line_locations_all PLL

525: INTO l_id_list,
526: l_del_flag_list,
527: l_txn_exists_list
528: FROM po_line_locations_draft_all PLLD,
529: po_line_locations_all PLL
530: WHERE PLLD.draft_id = p_draft_info.draft_id
531: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
532: AND PLLD.line_location_id = PLL.line_location_id(+);
533: