APPS.PO_EXHIBITS_PVT dependencies on PO_EXHIBIT_DETAILS_MERGE_V

Line 224: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v pex

220: FROM
221: (SELECT lookup_code
222: FROM fnd_lookup_values lk
223: WHERE lookup_type = 'PO_CLM_EXHIBIT_NUMBER'
224: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v pex
225: WHERE pex.po_header_id = p_header_id
226: AND pex.draft_id = p_draft_id
227: AND pex.exhibit_name = lk.lookup_code)
228: ORDER BY LENGTH(lookup_code),lookup_code

Line 1100: FROM po_exhibit_details_merge_v ex

1096:
1097: BEGIN
1098: SELECT Nvl(is_cdrl, 'N')
1099: INTO l_is_valid_exhibit
1100: FROM po_exhibit_details_merge_v ex
1101: WHERE ex.exhibit_name = p_exhibit_name_tbl(i)
1102: AND ex.draft_id = p_document_id_tbl(i) ;
1103:
1104: EXCEPTION

Line 1143: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v mex

1139: fnd_global.user_id,
1140: fnd_global.login_id
1141: FROM po_drafts dft
1142: WHERE dft.draft_id = p_document_id_tbl(i)
1143: AND NOT EXISTS (SELECT 1 FROM po_exhibit_details_merge_v mex
1144: WHERE mex.exhibit_name = p_exhibit_name_tbl(i)
1145: AND mex.draft_id = p_document_id_tbl(i));
1146:
1147: -- Records exists- Given exhibit is already been used by the Exhibit