eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PO_EDA_IDX_FILE_GEN SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16


SELECT  h.po_header_id documentId, h.draft_id draftId
FROM  po_headers_draft_all h, po_drafts d
WHERE  d.modification_number = p_clm_document_number
AND  d.document_id = h.po_header_id
AND  d.draft_id = h.draft_id;

Line: 23


SELECT  po_header_id documentId
FROM   po_headers_all
WHERE  clm_document_number = p_clm_document_number;

Line: 45


SELECT 'Y'
FROM po_headers_all
WHERE clm_award_type IN ('BPA_CALL','DELIVERY_ORD')
AND po_header_id = p_doc_id;

Line: 51


SELECT CLM_EFFECTIVE_DATE
FROM PO_HEADERS_ALL
WHERE po_header_id = p_doc_id;

Line: 70


		SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;

Line: 393


SELECT
clm_document_number
FROM
(SELECT CLM_DOCUMENT_NUMBER CLM_DOCUMENT_NUMBER, 'N' ismod,CLM_EFFECTIVE_DATE effdate,APPROVED_DATE APPROVED_DATE,CLM_EDAGEN_DATE
FROM po_headers_all
WHERE uda_template_id IS NOT NULL
UNION
SELECT modification_number CLM_DOCUMENT_NUMBER, 'Y' ismod,MOD_EFFECTIVE_DATE effdate,(select APPROVED_DATE from po_headers_merge_v where
 po_header_id = a.DOCUMENT_ID and draft_id = a.DRAFT_ID) APPROVED_DATE,CLM_EDAGEN_DATE
FROM po_drafts a)
WHERE (decode(P_IS_MOD,'Base Documents','N','Modifications','Y') = ismod or P_IS_MOD = 'Both')
AND
(
(l_approved_date is null and l_approved_date2 is null )
or (l_approved_date2 is null and l_approved_date is not null and APPROVED_DATE >= l_approved_date)
or (l_approved_date is null and l_approved_date2 is not null and APPROVED_DATE <= l_approved_date)
or (l_approved_date is not null and l_approved_date2 is not null and APPROVED_DATE between l_approved_date and l_approved_date2)
) and (
(l_effective_date is null and l_effective_date2 is null )
or (l_effective_date2 is null and l_effective_date is not null and effdate >= l_effective_date)
or (l_effective_date is null and l_effective_date2 is not null and effdate <= l_effective_date)
or (l_effective_date is not null and l_effective_date2 is not null and effdate between l_effective_date and l_effective_date2)
) and (
(p_doc_status = 'Approved' and p_eda_status = 'Generated' and CLM_EDAGEN_DATE >= APPROVED_DATE)
or (p_doc_status = 'Draft' and p_eda_status = 'Generated' and (
			(CLM_EDAGEN_DATE IS NOT NULL AND APPROVED_DATE IS NULL) or
			(CLM_EDAGEN_DATE < APPROVED_DATE)
			))
or (p_doc_status = 'Approved' and p_eda_status = 'Not Generated' and (
			(CLM_EDAGEN_DATE is null and APPROVED_DATE is not null) or
			(CLM_EDAGEN_DATE < APPROVED_DATE)
			))
or (p_doc_status = 'Draft' and p_eda_status = 'Not Generated' and CLM_EDAGEN_DATE is null and APPROVED_DATE is null)
or (p_doc_status = 'All' and p_eda_status = 'Generated' and CLM_EDAGEN_DATE is not null)
or (p_doc_status = 'All' and p_eda_status = 'Not Generated' and CLM_EDAGEN_DATE is null)
or (p_doc_status = 'Approved' and p_eda_status = 'All' and APPROVED_DATE is not null)
or (p_doc_status = 'Draft' and p_eda_status = 'All' and APPROVED_DATE is null)
or (p_doc_status = 'All' and p_eda_status = 'All')
) and
(
(
To_Number(SubStr(p_clm_document_number, InStr(p_clm_document_number,'-',1,1)+1,InStr(p_clm_document_number,'-',1,2) -
InStr(p_clm_document_number,'-',1,1) - 1)) =
To_Number(SubStr(p_clm_document_number2, InStr(p_clm_document_number2,'-',1,1)+1,InStr(p_clm_document_number2,'-',1,2) -
InStr(p_clm_document_number2,'-',1,1) - 1))
AND
To_Number(SubStr(p_clm_document_number, InStr(p_clm_document_number,'-',1,1)+1,InStr(p_clm_document_number,'-',1,2) -
InStr(p_clm_document_number,'-',1,1) - 1)) =
To_Number(SubStr(CLM_DOCUMENT_NUMBER, InStr(CLM_DOCUMENT_NUMBER,'-',1,1)+1,InStr(CLM_DOCUMENT_NUMBER,'-',1,2) -
InStr(CLM_DOCUMENT_NUMBER,'-',1,1) - 1))
AND

SubStr(p_clm_document_number, 1,InStr(p_clm_document_number,'-',1,1)-1) = SubStr(CLM_DOCUMENT_NUMBER,
1,InStr(CLM_DOCUMENT_NUMBER,'-',1,1)-1)
AND
SubStr(p_clm_document_number, 1,InStr(p_clm_document_number,'-',1,1)-1) = SubStr(p_clm_document_number2,
1,InStr(p_clm_document_number2,'-',1,1)-1)
AND
SubStr(p_clm_document_number, InStr(p_clm_document_number,'-',1,2)+1,InStr(p_clm_document_number,'-',1,3) -
InStr(p_clm_document_number,'-',1,2) - 1) =
SubStr(CLM_DOCUMENT_NUMBER, InStr(CLM_DOCUMENT_NUMBER,'-',1,2)+1,InStr(CLM_DOCUMENT_NUMBER,'-',1,3) -
InStr(CLM_DOCUMENT_NUMBER,'-',1,2) - 1)
AND
SubStr(p_clm_document_number, InStr(p_clm_document_number,'-',1,2)+1,InStr(p_clm_document_number,'-',1,3) -
InStr(p_clm_document_number,'-',1,2) - 1) =
SubStr(p_clm_document_number2, InStr(p_clm_document_number2,'-',1,2)+1,InStr(p_clm_document_number2,'-',1,3) -
InStr(p_clm_document_number2,'-',1,2) - 1)
AND

To_Number(Decode(InStr(CLM_DOCUMENT_NUMBER,'-',1,4),0,SubStr(CLM_DOCUMENT_NUMBER,
InStr(CLM_DOCUMENT_NUMBER,'-',1,3)+1),SubStr(CLM_DOCUMENT_NUMBER, InStr(CLM_DOCUMENT_NUMBER,'-',1,3)+1,
InStr(CLM_DOCUMENT_NUMBER,'-',1,4) - InStr(CLM_DOCUMENT_NUMBER,'-',1,3)-1 ))) BETWEEN
To_Number(Decode(InStr(p_clm_document_number,'-',1,4),0,SubStr(p_clm_document_number,
InStr(p_clm_document_number,'-',1,3)+1),substr(p_clm_document_number,
instr(p_clm_document_number,'-',1,3)+1,instr(p_clm_document_number,'-',1,4) - instr(p_clm_document_number,'-',1,3)-1))) AND
To_Number(Decode(InStr(p_clm_document_number2,'-',1,4),0,SubStr(p_clm_document_number2,
InStr(p_clm_document_number2,'-',1,3)+1),substr(p_clm_document_number2,
instr(p_clm_document_number2,'-',1,3)+1,instr(p_clm_document_number2,'-',1,4) - instr(p_clm_document_number2,'-',1,3)-1)))
)
OR
(
SubStr(p_clm_document_number, 1,InStr(p_clm_document_number,'-',1,1)-1) = SubStr(CLM_DOCUMENT_NUMBER,
1,InStr(CLM_DOCUMENT_NUMBER,'-',1,1)-1)
AND
SubStr(p_clm_document_number, 1,InStr(p_clm_document_number,'-',1,1)-1) = SubStr(p_clm_document_number2,
1,InStr(p_clm_document_number2,'-',1,1)-1)
AND
SubStr(p_clm_document_number, InStr(p_clm_document_number,'-',1,2)+1,InStr(p_clm_document_number,'-',1,3) -
InStr(p_clm_document_number,'-',1,2) - 1) =
SubStr(CLM_DOCUMENT_NUMBER, InStr(CLM_DOCUMENT_NUMBER,'-',1,2)+1,InStr(CLM_DOCUMENT_NUMBER,'-',1,3) - InStr(CLM_DOCUMENT_NUMBER,'-',1,2)
- 1)
AND
SubStr(p_clm_document_number, InStr(p_clm_document_number,'-',1,2)+1,
InStr(p_clm_document_number,'-',1,3) - InStr(p_clm_document_number,'-',1,2) - 1) =
SubStr(p_clm_document_number2, InStr(p_clm_document_number2,'-',1,2)+1,
InStr(p_clm_document_number2,'-',1,3) - InStr(p_clm_document_number2,'-',1,2) - 1)
AND

To_Number(SubStr(p_clm_document_number, InStr(p_clm_document_number,'-',1,1)+1,InStr(p_clm_document_number,'-',1,2) -
InStr(p_clm_document_number,'-',1,1) - 1)) <
To_Number(SubStr(p_clm_document_number2, InStr(p_clm_document_number2,'-',1,1)+1,InStr(p_clm_document_number2,'-',1,2) -
InStr(p_clm_document_number2,'-',1,1) - 1))
AND
(
To_Number(Decode(InStr(CLM_DOCUMENT_NUMBER,'-',1,4),0,SubStr(CLM_DOCUMENT_NUMBER,
InStr(CLM_DOCUMENT_NUMBER,'-',1,3)+1),SubStr(CLM_DOCUMENT_NUMBER, InStr(CLM_DOCUMENT_NUMBER,'-',1,3)+1,InStr(CLM_DOCUMENT_NUMBER,'-',1,4)
- InStr(CLM_DOCUMENT_NUMBER,'-',1,3)-1 ))) >=
To_Number(Decode(InStr(p_clm_document_number,'-',1,4),0,SubStr(p_clm_document_number,
InStr(p_clm_document_number,'-',1,3)+1),substr(p_clm_document_number,
instr(p_clm_document_number,'-',1,3)+1,instr(p_clm_document_number,'-',1,4) - instr(p_clm_document_number,'-',1,3)-1)))
 AND
To_Number(Decode(InStr(CLM_DOCUMENT_NUMBER,'-',1,4),0,SubStr(CLM_DOCUMENT_NUMBER,
InStr(CLM_DOCUMENT_NUMBER,'-',1,3)+1),SubStr(CLM_DOCUMENT_NUMBER, InStr(CLM_DOCUMENT_NUMBER,'-',1,3)+1,InStr(CLM_DOCUMENT_NUMBER,'-',1,4)
- InStr(CLM_DOCUMENT_NUMBER,'-',1,3)-1 ))) <=
To_Number(Decode(InStr(p_clm_document_number2,'-',1,4),0,SubStr(p_clm_document_number2,
InStr(p_clm_document_number2,'-',1,3)+1),substr(p_clm_document_number2,
instr(p_clm_document_number2,'-',1,3)+1,instr(p_clm_document_number2,'-',1,4) - instr(p_clm_document_number2,'-',1,3)-1)))
 )
)
OR ( p_clm_document_number2 is null and CLM_DOCUMENT_NUMBER = p_clm_document_number )
OR ( p_clm_document_number is null and CLM_DOCUMENT_NUMBER = p_clm_document_number2 )
) ;

Line: 526


SELECT ARGUMENT1,ARGUMENT2,to_timestamp(ARGUMENT8,'YYYYMMDDHH24MISSSSS')
FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =p_parent_id AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8
AND 3 = (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND
t.PARENT_REQUEST_ID = i.PARENT_REQUEST_ID);

Line: 540


    SELECT Trim(FND_PROFILE.VALUE('PO_EDA_FILES_LOCATION')) INTO v_out_dir FROM dual;

Line: 546


	  SELECT FND_PROFILE.VALUE('PO_EDA_BATCH_SIZE') into l_max_doc_in_batch FROM dual;

Line: 617


         SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER =  l_doc_numbers(i);

Line: 737


         SELECT ismod INTO l_base_or_mod FROM po_eda_clm_doc_nbr_v WHERE CLM_DOCUMENT_NUMBER =  l_doc_numbers(i);

Line: 831


		UPDATE po_headers_all SET CLM_EDAGEN_DATE = l_timestamp WHERE CLM_DOCUMENT_NUMBER = l_doc_number;

Line: 833


		UPDATE po_drafts SET CLM_EDAGEN_DATE = l_timestamp WHERE MODIFICATION_NUMBER = l_doc_number;

Line: 841


	SELECT 'Y' into l_warning_flag
	FROM dual where EXISTS(
	SELECT 1
	FROM FND_CONCURRENT_REQUESTS t WHERE PARENT_REQUEST_ID =FND_GLOBAL.CONC_REQUEST_ID AND ARGUMENT1 = 'N' AND NUMBER_OF_ARGUMENTS = 8
	AND 3 > (SELECT Count(1) FROM FND_CONCURRENT_REQUESTS i WHERE i.ARGUMENT2 = t.ARGUMENT2 AND i.STATUS_CODE = 'C' AND
	t.PARENT_REQUEST_ID = i.PARENT_REQUEST_ID));