APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PO_LINES_MERGE_V

Line 1107: FROM po_lines_merge_v modif

1103: RETURN VARCHAR2 IS
1104:
1105: CURSOR exists_exercised_options IS
1106: SELECT 'Y'
1107: FROM po_lines_merge_v modif
1108: WHERE po_header_id = p_po_header_id
1109: AND draft_id = p_draft_id
1110: AND CLM_EXERCISED_FLAG = 'Y'
1111: AND EXISTS (SELECT 1

Line 1112: FROM po_lines_merge_v base

1108: WHERE po_header_id = p_po_header_id
1109: AND draft_id = p_draft_id
1110: AND CLM_EXERCISED_FLAG = 'Y'
1111: AND EXISTS (SELECT 1
1112: FROM po_lines_merge_v base
1113: WHERE modif.po_line_id = base.po_line_id
1114: AND po_header_id = p_po_header_id
1115: AND draft_id = -1
1116: AND Nvl(CLM_EXERCISED_FLAG,'N')='N');

Line 1120: FROM po_lines_merge_v

1116: AND Nvl(CLM_EXERCISED_FLAG,'N')='N');
1117:
1118: CURSOR exists_new_lines IS
1119: SELECT 'Y'
1120: FROM po_lines_merge_v
1121: WHERE po_header_id = p_po_header_id
1122: AND draft_id = p_draft_id
1123: AND CHANGE_STATUS = 'NEW';
1124: