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 383: FROM po_line_locations_draft_all POLLD,

379: num1
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'

Line 401: FROM po_line_locations_draft_all POLLD,

397: num1
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'

Line 528: FROM po_line_locations_draft_all PLLD,

524: BULK COLLECT
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(+);