APPS.PO_LINE_LOCATIONS_DRAFT_PVT dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 98: FROM po_line_locations_draft_all PLLD

94: SELECT l_key,
95: l_index_tbl(i)
96: FROM DUAL
97: WHERE EXISTS (SELECT 1
98: FROM po_line_locations_draft_all PLLD
99: WHERE PLLD.draft_id = p_draft_id_tbl(i)
100: AND PLLD.line_location_id = NVL(p_line_location_id_tbl(i),
101: PLLD.line_location_id)
102: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y');

Line 342: FROM po_line_locations_draft_all POLLD,

338: num1
339: )
340: SELECT l_key,
341: POLLD.po_line_id
342: FROM po_line_locations_draft_all POLLD,
343: po_line_locations_all POLL
344: WHERE POLLD.draft_id = p_draft_info.draft_id
345: AND POLLD.line_location_id = POLL.line_location_id (+)
346: AND NVL(POLLD.change_accepted_flag, 'Y') = 'Y'

Line 360: FROM po_line_locations_draft_all POLLD,

356: num1
357: )
358: SELECT l_key,
359: POLLD.po_line_id
360: FROM po_line_locations_draft_all POLLD,
361: po_line_locations_all POLL
362: WHERE POLLD.draft_id = p_draft_info.draft_id
363: AND POLLD.line_location_id = POLL.line_location_id
364: AND NVL(POLLD.change_accepted_flag, 'Y') = 'Y'

Line 487: FROM po_line_locations_draft_all PLLD,

483: BULK COLLECT
484: INTO l_id_list,
485: l_del_flag_list,
486: l_txn_exists_list
487: FROM po_line_locations_draft_all PLLD,
488: po_line_locations_all PLL
489: WHERE PLLD.draft_id = p_draft_info.draft_id
490: AND NVL(PLLD.change_accepted_flag, 'Y') = 'Y'
491: AND PLLD.line_location_id = PLL.line_location_id(+);