DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_DRAFT_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 343: po_line_locations_all POLL

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'
347: AND (NVL(POLLD.delete_flag, 'N') = 'Y' OR

Line 361: po_line_locations_all POLL

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'
365: AND NVL(POLLD.delete_flag, 'N') = 'N'

Line 488: po_line_locations_all PLL

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(+);
492: