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.

APPS.PO_EDA_DATATEMPLATE_PKG SQL Statements

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

Line: 98


SELECT paha.solicitation_type
from pon_auction_headers_all paha, pon_bid_headers pbh
WHERE pbh.po_header_id = DOCUMENTID
and pbh.auction_header_id = paha.auction_header_id;

Line: 132


SELECT 'Y' FROM dual
WHERE EXISTS (SELECT 1 FROM okc_k_articles_b kartb, okc_articles_all art
              WHERE kartb.sav_sae_id = art.article_id
              AND article_number = clause_t);

Line: 176


SELECT 'true'
FROM po_lines_merge_v pol
WHERE
		 ( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) )
AND  CONTRACT_TYPE IN ('COST_PLUS_AWARD_FEE','FP_AWARD_FEE') ;

Line: 194


SELECT 'true'
FROM po_lines_merge_v pol
WHERE
		 ( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DOCUMENTID AND pol.change_status IS NOT NULL)) )
AND  CONTRACT_TYPE IN ('COST_PLUS_INCENTIVE_FEE','FP_INCENTIVE_SUCCESSIVE_TARGET','FP_INCENTIVE_FIRM_TARGET') ;

Line: 214


SELECT 'true' FROM (
SELECT Count(DISTINCT art.article_title) AS articles FROM okc_k_articles_b kartb, okc_article_versions ver, okc_articles_all art
WHERE kartb.article_version_id = ver.article_version_id
AND   kartb.sav_Sae_id = art.article_id
AND   ver.article_id = art.article_id
AND   kartb.document_id in
				(SELECT DISTINCT AUCTION_HEADER_ID FROM pon_bid_headers WHERE bid_number in
				(SELECT bid_number FROM po_lines_all WHERE po_header_id  = DOCUMENTID))
AND   kartb.document_type = 'SOLICITATION'
AND (  (art.article_title LIKE '52.212-1%' AND ver.INSERT_BY_REFERENCE = 'Y')
OR   (art.article_title LIKE '52.212-4%' AND ver.INSERT_BY_REFERENCE = 'Y')
OR   (art.article_title LIKE '52.212-3%' AND ver.INSERT_BY_REFERENCE = 'N')
OR   (art.article_title LIKE '52.212-5%' AND ver.INSERT_BY_REFERENCE = 'N') )) WHERE articles = 4;

Line: 267


      SELECT 	ag.attr_group_id,
              efdfce.application_column_name
      into   l_attr_grp_id, l_col_name
      FROM ego_fnd_dsc_flx_ctx_ext ag,
           ego_fnd_df_col_usgs_ext efdfce,
           fnd_descr_flex_column_usages fcu
      WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
      and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
      and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
      and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
      and fcu.application_column_name = efdfce.application_column_name
      and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_HEADER_EXT_ATTRS'
      and upper(ag.descriptive_flex_context_code) = upper('addresses')
      and upper(fcu.end_user_column_name) = upper('addressdtlsxml');

Line: 284


      l_addr_sql := 'select ' || l_col_name || ' as address ' ;

Line: 324


      SELECT 	ag.attr_group_id,
              efdfce.application_column_name
      into   l_attr_grp_id, l_col_name
      FROM ego_fnd_dsc_flx_ctx_ext ag,
           ego_fnd_df_col_usgs_ext efdfce,
           fnd_descr_flex_column_usages fcu
      WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
      and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
      and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
      and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
      and fcu.application_column_name = efdfce.application_column_name
      and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_HEADER_EXT_ATTRS'
      and upper(ag.descriptive_flex_context_code) = upper('addresses')
      and upper(fcu.end_user_column_name) = upper('contactdtlsxml');

Line: 341


      l_cnt_sql := 'select ' || l_col_name || ' as contacts ' ;

Line: 390


    SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
          AG.ATTR_GROUP_ID ATTR_GROUP_ID,
          AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
          AG.MULTI_ROW MULTI_ROW
    FROM EGO_FND_DSC_FLX_CTX_EXT AG,
         PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
    WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
    AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
    AND AG.ATTR_GROUP_ID  = POTU.ATTRIBUTE_GROUP_ID
    AND potu.attribute_group_id in (select distinct attr_group_id
                                    from po_headers_all_ext_b
                                    where po_header_id = DOCUMENTID
                                    and draft_id = DRAFTID and uda_template_id = potu.template_id
                                    and attr_group_id = potu.attribute_group_id)
    ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 407


    SELECT   EFDFCE.ATTR_ID                ,
    EFDFCE.APPLICATION_COLUMN_NAME      ,
    FCU.END_USER_COLUMN_NAME,
    fcu.flex_value_set_id,
    EFDFCE.data_type
    FROM
      EGO_FND_DF_COL_USGS_EXT EFDFCE,
      FND_DESCR_FLEX_COLUMN_USAGES FCU
    WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
    AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE  = P_ATTR_GROUP
    AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
    AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
    AND FCU.APPLICATION_COLUMN_NAME = EFDFCE.APPLICATION_COLUMN_NAME;

Line: 432


  DELETE po_eda_uda_attr_values WHERE pk1_value = DOCUMENTID AND lvl = 'AWARDHEADER' AND pk2_value = DRAFTID;

Line: 435


      l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_headers_all_ext_vl where po_header_id = '  || DOCUMENTID ||
	  ' AND draft_id = ' || DRAFTID || ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID;

Line: 442


      INSERT INTO  po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (DOCUMENTID, DRAFTID,'AWARDHEADER',REC.ATTR_GROUP||'_'||R.END_USER_COLUMN_NAME,l_value);

Line: 452


      SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
            AG.ATTR_GROUP_ID ATTR_GROUP_ID,
            AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
            AG.MULTI_ROW MULTI_ROW
      FROM EGO_FND_DSC_FLX_CTX_EXT AG,
          PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
      WHERE POTU.TEMPLATE_ID IN (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINES_MERGE_V WHERE PO_HEADER_ID = DOCUMENTID AND
	  DRAFT_ID=DRAFTID)
	  AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
      AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
      AND AG.ATTR_GROUP_ID  = POTU.ATTRIBUTE_GROUP_ID
      AND potu.attribute_group_id in (select distinct attr_group_id
                                      from po_lines_all_ext_b
                                      where po_line_id = p_po_line_id
                                      and draft_id = DRAFTID
                                      and attr_group_id = potu.attribute_group_id
                                      and pk1_value IS NULL)
      ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 472


      SELECT   EFDFCE.ATTR_ID                ,
      EFDFCE.APPLICATION_COLUMN_NAME      ,
      FCU.END_USER_COLUMN_NAME,
      fcu.flex_value_set_id,
      EFDFCE.data_type
      FROM
        EGO_FND_DF_COL_USGS_EXT EFDFCE ,
        FND_DESCR_FLEX_COLUMN_USAGES FCU
      WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
      AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE  = P_ATTR_GROUP
      AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
      AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
      AND FCU.APPLICATION_COLUMN_NAME = EFDFCE.APPLICATION_COLUMN_NAME;

Line: 488


      SELECT po_line_id
      FROM po_lines_merge_v
      WHERE draft_id = DRAFTID
	  and po_header_id = DOCUMENTID;

Line: 505


   DELETE FROM po_eda_uda_attr_values WHERE pk1_value = c.po_line_id AND lvl='AWARDLINE' AND pk2_value = DRAFTID;

Line: 509


      l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_lines_all_ext_vl where po_line_id = '  || c.po_line_id ||
	  ' AND draft_id = ' || DRAFTID || ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID;

Line: 514


      INSERT INTO  po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (c.po_line_id,
	  DRAFTID,'AWARDLINE',REC.ATTR_GROUP||'_'||R.END_USER_COLUMN_NAME,l_value);

Line: 526


    SELECT AG.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP,
          AG.ATTR_GROUP_ID ATTR_GROUP_ID,
          AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
          AG.MULTI_ROW MULTI_ROW
    FROM EGO_FND_DSC_FLX_CTX_EXT AG,
          PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
    WHERE POTU.TEMPLATE_ID IN
				(SELECT DISTINCT UDA_TEMPLATE_ID FROM  PO_LINE_LOCATIONS_MERGE_V WHERE PO_HEADER_ID =DOCUMENTID AND DRAFT_ID = DRAFTID)
	AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
    AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
    AND AG.ATTR_GROUP_ID  = POTU.ATTRIBUTE_GROUP_ID
    AND potu.attribute_group_id in (select distinct attr_group_id
                                    from po_line_locations_all_ext_b
                                    where line_location_id = p_line_location_id
                                    and draft_id = DRAFTID
                                  and attr_group_id = potu.attribute_group_id)
    ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 545


      SELECT   EFDFCE.ATTR_ID                ,
      EFDFCE.APPLICATION_COLUMN_NAME      ,
      FCU.END_USER_COLUMN_NAME,
      fcu.flex_value_set_id,
      EFDFCE.data_type
      FROM
      EGO_FND_DF_COL_USGS_EXT EFDFCE
      , FND_DESCR_FLEX_COLUMN_USAGES FCU
      WHERE EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEXFLD_NAME
      AND EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE  = P_ATTR_GROUP
      AND FCU.DESCRIPTIVE_FLEX_CONTEXT_CODE = EFDFCE.DESCRIPTIVE_FLEX_CONTEXT_CODE
      AND FCU.DESCRIPTIVE_FLEXFIELD_NAME = EFDFCE.DESCRIPTIVE_FLEXFIELD_NAME
      AND FCU.APPLICATION_COLUMN_NAME = EFDFCE.APPLICATION_COLUMN_NAME;

Line: 561


      SELECT poll.LINE_LOCATION_ID
      FROM  po_lines_merge_v pol , po_line_locations_merge_v poll
      WHERE pol.po_header_id =   DOCUMENTID
      AND   poll.po_header_id =   DOCUMENTID
	  AND   pol.DRAFT_ID =   DRAFTID
      AND   poll.DRAFT_ID =   pol.DRAFT_ID
      AND   poll.po_line_id = pol.po_line_id;

Line: 584


   DELETE po_eda_uda_attr_values WHERE pk1_value = c.LINE_LOCATION_ID AND lvl = 'AWARDLINELOC' AND pk2_value = DRAFTID;

Line: 588


      l_sql2 := 'select '||R.APPLICATION_COLUMN_NAME || ' from po_line_locations_all_ext_vl where line_location_id = '  ||
	  c.LINE_LOCATION_ID || ' AND draft_id = ' || DRAFTID ||
               ' AND pk1_value IS NULL and attr_group_id = ' || REC.ATTR_GROUP_ID;

Line: 592


      INSERT INTO  po_eda_uda_attr_values(pk1_value,pk2_value,lvl,attr, attrval) VALUES (c.LINE_LOCATION_ID,DRAFTID
	  ,'AWARDLINELOC',REC.ATTR_GROUP||'_'||R.END_USER_COLUMN_NAME,l_value);

Line: 642


        SELECT 	ag.attr_group_id,
          efdfce.application_column_name
          into   l_attr_grp_id, l_col_name

          FROM ego_fnd_dsc_flx_ctx_ext ag,
             ego_fnd_df_col_usgs_ext efdfce,
             fnd_descr_flex_column_usages fcu

        WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
        and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
        and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
        and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
        and fcu.application_column_name = efdfce.application_column_name
        and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_SHIPMENTS_EXT_ATTRS'
        and upper(ag.descriptive_flex_context_code) = upper('SHIP_INFO')
        and upper(fcu.end_user_column_name) = upper('hiddShipAddXml');

Line: 661


        l_addr_sql := 'select ' || l_col_name || ' as ship_address ' ;

Line: 674


		select '' into clob_addr
		from dual;

Line: 694


  SELECT 'true'
  FROM okc_k_articles_b kartb, okc_articles_all art
  WHERE kartb.sav_sae_id = art.article_id
  AND   kartb.document_id = p_doc_id
  AND   kartb.document_type = p_doc_type
  AND   art.article_number = '252.232-7011';

Line: 716


  SELECT 'true'
  FROM okc_k_articles_b kartb, okc_articles_all art
  WHERE kartb.sav_sae_id = art.article_id
  AND   kartb.document_id = p_doc_id
  AND   kartb.document_type = p_doc_type
  AND   art.article_number IN ('252.225-7997 (DEV)','252.232-7011','252.237-7023');

Line: 737


SELECT article_text
FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
WHERE kartb.document_type = DOCUMENTTYPE
AND kartb.document_id = decode(ISMOD,'N',DOCUMENTID,DRAFTID)
AND kartb.sav_sae_id = art.article_id
AND kartb.article_version_id = ver.article_version_id
AND art.article_id = ver.article_id
AND art.standard_yn = 'N'
AND kartb.ref_article_id IS NULL
AND KARTB.scn_id = p_scn_id;

Line: 763


SELECT ARTICLE_TEXT
FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver
WHERE kartb.sav_sae_id = art.article_id
AND   art.article_id = ver.article_id
AND document_id = Decode(isMod,'N',DOCUMENTID,'Y',DRAFTID,DOCUMENTID)
AND   kartb.document_type = DOCUMENTTYPE
AND   article_type IN ('SOW','PWS');

Line: 785


SELECT  Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'GOVT_SHARE_PER'))
FROM po_lines_merge_v pol
WHERE
		 ( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) );

Line: 808


SELECT  Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'GOVT_SH_AMOUNT'))
FROM po_lines_merge_v  pol
WHERE
		 ( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) );

Line: 833


SELECT  Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => po_line_id, pk2_value => DRAFTID,
p_attr_grp_int_name => 'AMT_CS_IIQ', p_attr_int_name => 'CONT_SH_AMOUNT'))
FROM po_lines_merge_v pol
WHERE
		 ( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) );

Line: 860


po_gen_diff_pkg.delete_differences('AWARD','ALL','PO_ENTITY_DIFFERENCES',NULL,NULL,NULL,NULL,NULL,DOCUMENTID,DRAFTID,NULL,NULL,NULL);

Line: 869


SELECT Nvl(orig_value_desc,orig_value) Orig_value,Nvl(mod_value_desc,mod_value) Mod_value,
Decode(orig_value,NULL,Decode(mod_value,NULL,'No Change','Added'),
                  Mod_value,'No Change',
                  Decode(mod_value,NULL,'Deleted','Modified')) ChangeFlag,
Decode(orig_value,NULL,Decode(mod_value,NULL,'No Change','New value '''||Nvl(mod_value_desc,mod_value)||''' Added'),
                  Mod_value,'No Change',
                  Decode(mod_value,NULL,'value '''||Nvl(orig_value_desc,orig_value)||''' Deleted','Value modified from '''||Nvl(orig_value_desc,orig_value)||''' to '''||Nvl(mod_value_desc,mod_value)||'''')) ChangeText
FROM po_entity_differences
WHERE MOD_DOC_PK1_VAL = DOCUMENTID
AND MOD_DOC_PK2_VAL = DRAFTID
AND Nvl(MOD_DOC_PK3_VAL,-1) = Nvl(p_line_id,-1)
AND Nvl(MOD_DOC_PK4_VAL,-1) = Nvl(p_line_location_id,-1)
AND Nvl(MOD_DOC_PK5_VAL,-1) = Nvl(p_distribution_id,-1)
AND column_name =  p_column_name;

Line: 885


SELECT 'Y'
FROM po_entity_differences
WHERE MOD_DOC_PK1_VAL = DOCUMENTID
AND MOD_DOC_PK2_VAL = DRAFTID
AND Nvl(MOD_DOC_PK3_VAL,-1) = Nvl(p_line_id,-1)
AND Nvl(MOD_DOC_PK4_VAL,-1) = Nvl(p_line_location_id,-1)
AND Nvl(MOD_DOC_PK5_VAL,-1) = Nvl(p_distribution_id,-1)
AND column_name =  p_column_name;

Line: 926


SELECT p_old_value Orig_value,p_new_value Mod_value,
Decode(p_old_value,NULL,Decode(p_new_value,NULL,'No Change','Added'),
                  p_new_value,'No Change',
                  Decode(p_new_value,NULL,'Deleted','Modified')) ChangeFlag,
Decode(p_old_value,NULL,Decode(p_new_value,NULL,'No Change','New value '''||p_new_value||''' Added'),
                  p_new_value,'No Change',
                  Decode(p_new_value,NULL,'value '''||p_old_value||''' Deleted','Value modified from '''||p_old_value||
				  ''' to '''||p_new_value||'''')) ChangeText
FROM dual;

Line: 961


SELECT Nvl(orig_value_desc,orig_value) Orig_value,Nvl(mod_value_desc,mod_value) Mod_value,
Decode(orig_value,NULL,Decode(mod_value,NULL,'No Change','Added'),
                  Mod_value,'No Change',
                  Decode(mod_value,NULL,'Deleted','Modified')) ChangeFlag,
Decode(orig_value,NULL,Decode(mod_value,NULL,'No Change','New value '''||Nvl(mod_value_desc,mod_value)||''' Added'),
                  Mod_value,'No Change',
                  Decode(mod_value,NULL,'value '''||Nvl(orig_value_desc,orig_value)||''' Deleted','Value modified from '''||
				  Nvl(orig_value_desc,orig_value)||''' to '''||Nvl(mod_value_desc,mod_value)||'''')) ChangeText
FROM po_entity_differences
WHERE  MOD_DOC_PK1_VAL = DOCUMENTID
AND MOD_DOC_PK2_VAL = DRAFTID
AND Nvl(MOD_DOC_PK3_VAL,-1) = Nvl(p_line_id,-1)
AND Nvl(MOD_DOC_PK4_VAL,-1) = Nvl(p_line_location_id,-1)
AND Nvl(MOD_DOC_PK5_VAL,-1) = Nvl(p_distribution_id,-1)
AND column_name =  p_column_name;

Line: 979


SELECT CASE WHEN poh.start_date IS NULL AND poh.end_date IS NULL AND Min(CLM_PERIOD_PERF_START_DATE) IS NULL AND
Max(CLM_PERIOD_PERF_END_DATE) IS NULL THEN 'Delivery Requested By' ELSE NULL END DeliveryDescription,
to_char(CASE WHEN poh.start_date IS NULL AND poh.end_date IS NULL AND Min(CLM_PERIOD_PERF_START_DATE) IS NULL AND
 Max(CLM_PERIOD_PERF_END_DATE) IS NULL THEN ploc.NEED_BY_DATE ELSE NULL END,'CCYY-MM-DD') DateElement
FROM po_headers_merge_v poh, po_lines_merge_v pol , po_line_locations_merge_v ploc
WHERE
( ( (isMod = 'N')  AND (poh.po_header_id = DOCUMENTID AND poh.draft_id = -1  AND poh.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) )
AND
( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) )
AND
( ( (isMod = 'N')  AND (ploc.po_header_id = DOCUMENTID AND ploc.draft_id = -1  AND ploc.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (ploc.draft_id = DRAFTID AND ploc.change_status IS NOT NULL)) )
AND poh.po_header_id = pol.po_header_id
AND   pol.po_line_id   = ploc.po_line_id
GROUP BY poh.start_date, poh.end_date, ploc.need_by_date ;

Line: 999


WITH q_termid AS(SELECT poh.terms_id v_term
FROM po_headers_merge_v poh
WHERE
 ( ( (isMod = 'N')  AND (poh.po_header_id = DOCUMENTID AND poh.draft_id = -1  AND poh.change_status is NULL)) OR
    ( (isMod = 'Y')  AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) )
),
q_netdays AS (SELECT Sum(DUE_DAYS) NetDays FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
q_discount1 AS (SELECT DISCOUNT_PERCENT Percent,DISCOUNT_DAYS DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
q_discount2 AS (SELECT DISCOUNT_PERCENT_2 Percent,DISCOUNT_DAYS_2 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
q_discount3 AS (SELECT DISCOUNT_PERCENT_3 Percent,DISCOUNT_DAYS_3 DaysDue FROM ap_terms_lines a, q_termid t WHERE a.term_id = t.v_term),
q_discount AS (
(SELECT Percent,DaysDue FROM q_discount1) UNION (SELECT Percent,DaysDue FROM q_discount2) UNION
(SELECT Percent,DaysDue FROM q_discount3)
) SELECT Percent,DaysDue,NetDays FROM q_discount,q_netdays;

Line: 1014


/*SELECT t.DUE_PERCENT Percent, t.DUE_DAYS DaysDue, (SYSDATE - t.DUE_DAYS) NetDays
FROM po_headers_merge_v poh, ap_terms_lines t
WHERE poh.terms_id = t.term_id
and   ( ( (isMod = 'N')  AND (poh.po_header_id = DOCUMENTID AND poh.draft_id = -1  AND poh.change_status is NULL)) OR
    ( (isMod = 'Y')  AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) );*/

Line: 1022


SELECT po_distribution_id
FROM po_distributions_all
WHERE po_header_id = DOCUMENTID;

Line: 1027


SELECT po_distribution_id po_dist_id,'Added' change_status FROM  po_distributions_merge_v a WHERE po_header_id = DOCUMENTID
AND draft_id = DRAFTID
AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND
draft_id  = -1);

Line: 1033


CURSOR c_deletedObligatedAmounts IS
SELECT po_distribution_id po_dist_id,'Deleted' change_status FROM  po_distributions_merge_v a WHERE po_header_id = DOCUMENTID
AND draft_id = -1
AND NOT EXISTS (SELECT 1 FROM po_distributions_merge_v WHERE po_distribution_id = a.po_distribution_id AND
draft_id  = DRAFTID);

Line: 1040


SELECT modi.po_distribution_id po_dist_id,'Modified' change_status FROM  po_distributions_merge_v base,po_distributions_merge_v modi
 WHERE base.po_header_id = DOCUMENTID AND modi.po_header_id = base.po_header_id
AND modi.draft_id = DRAFTID AND base.draft_id = -1
AND modi.CHANGE_STATUS = 'UPDATE'
AND (modi.CODE_COMBINATION_ID <> base.CODE_COMBINATION_ID
OR modi.CLM_MISC_LOA <> base.CLM_MISC_LOA
OR modi.CLM_AGENCY_ACCT_IDENTIFIER <> base.CLM_AGENCY_ACCT_IDENTIFIER
OR modi.ACRN <> base.ACRN
OR modi.AMOUNT_FUNDED <> base.AMOUNT_FUNDED);

Line: 1051


SELECT NVL((select eda from po_eda_mapping where GROUPING = 'LOA' and attribute = 'ComponentTitle' and
	ebs = flv.SEGMENT_NAME),flv.SEGMENT_NAME) ComponentTitle,
	 PO_EDA_DATATEMPLATE_PKG.get_charge_acc_comp_val(flv.APPLICATION_COLUMN_NAME,pda.CODE_COMBINATION_ID) ComponentValue
FROM fnd_id_flex_segments_vl flv, gl_code_combinations glc, po_distributions_merge_v pda
WHERE po_distribution_id  = p_dist_id and draft_id = p_draft_id
	AND glc.CODE_COMBINATION_ID = pda.CODE_COMBINATION_ID
    AND flv.ID_FLEX_CODE = 'GL#'  AND flv.ID_FLEX_NUM =  glc.CHART_OF_ACCOUNTS_ID ;

Line: 1061


select 'Firm Price','Target Price','Funded Amount','Award Fee','Base Price','Celing Price','Estimated Cost','Fixed Fee','Target Cost' AmountType from dual;

Line: 1115


SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'N') MiscellaneousText
FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
WHERE kartb.document_id = DOCUMENTID
AND kartb.sav_sae_id = art.article_id
AND kartb.article_version_id = ver.article_version_id
AND art.article_id = ver.article_id
AND art.standard_yn = 'N'
AND kartb.ref_article_id IS NULL
GROUP BY scn_id
ORDER BY scn_id;

Line: 1127


SELECT (SELECT heading FROM okc_sections_b WHERE id = kartb.scn_id) Section,get_miscclausetxt(scn_id,'Y') MiscellaneousText
FROM okc_k_articles_b kartb, okc_articles_all art, okc_article_versions ver
WHERE kartb.document_id = DRAFTID
AND kartb.sav_sae_id = art.article_id
AND kartb.article_version_id = ver.article_version_id
AND art.article_id = ver.article_id
AND art.standard_yn = 'N'
AND kartb.ref_article_id IS NULL
GROUP BY scn_id
ORDER BY scn_id;

Line: 1238


select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
INTO l_prev3
from (
SELECT CASE
  WHEN cnt = 1 THEN
  (
  SELECT distinct contract_type FROM po_lines_merge_v
      WHERE po_header_id = DOCUMENTID AND draft_id = -1  AND change_status is NULL and contract_type is not null
  )
  ELSE 'FFP'
END  AS contract_type FROM (
    SELECT Count(distinct contract_type) AS cnt FROM po_lines_merge_v
    WHERE po_header_id = DOCUMENTID AND draft_id = -1  AND change_status is NULL AND contract_type is not null )
 );

Line: 1255


select PO_EDA_DATATEMPLATE_PKG.get_PricingArrangementBase(contract_type) PricingArrangementBase
INTO l_mod3
from (
SELECT CASE
  WHEN cnt = 1 THEN
  (
  SELECT distinct contract_type FROM po_lines_merge_v
      WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID  AND change_status is NOT NULL and contract_type is not null
  )
  ELSE 'FFP'
END  AS contract_type FROM (
    SELECT Count(distinct contract_type) AS cnt FROM po_lines_merge_v
    WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID  AND change_status is NOT NULL AND contract_type is not null )
 );

Line: 1271


ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Award Fee Value '||l_prev1||' deleted';

Line: 1276


ELSIF l_prev2 IS NOT NULL AND l_mod2 IS NULL THEN l_chg2:= 'Deleted';  l_chgtxt2:= 'Performance Incentive Value '||l_prev2||' deleted';

Line: 1281


ELSIF l_prev3 IS NOT NULL AND l_mod3 IS NULL THEN l_chg3:= 'Deleted';  l_chgtxt3:= 'Price Arrangement Base Value '||l_prev3||' deleted';

Line: 1312


ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Value '||l_prev1||' deleted';

Line: 1317


ELSIF l_prev2 IS NOT NULL AND l_mod2 IS NULL THEN l_chg2:= 'Deleted';  l_chgtxt2:= 'Value '||l_prev2||' deleted';

Line: 1322


ELSIF l_prev3 IS NOT NULL AND l_mod3 IS NULL THEN l_chg3:= 'Deleted';  l_chgtxt3:= 'Value '||l_prev3||' deleted';

Line: 1359


IF l_chg1 = 'Deleted' OR l_chg2 = 'Deleted' OR l_chg3 = 'Deleted' THEN
l_clob := l_clob || '';

Line: 1361


  IF l_chg1 = 'Deleted' OR l_chg2 = 'Deleted' THEN
    l_clob := l_clob || '';

Line: 1364


    IF l_chg1 = 'Deleted' THEN
      l_clob := l_clob || '' || l_prev1 || '';

Line: 1367


    IF l_chg2 = 'Deleted' THEN
      l_clob := l_clob || '' || l_prev2 || '';

Line: 1372


  IF l_chg1 = 'Deleted' OR l_chg3 = 'Deleted' THEN
    l_clob := l_clob || '';

Line: 1375


    IF l_chg1 = 'Deleted' THEN
      l_clob := l_clob || '' || l_prev1 || '';

Line: 1378


    IF l_chg3 = 'Deleted' THEN
      l_clob := l_clob || '' || l_prev3 || '';

Line: 1383


l_clob := l_clob || '';

Line: 1621


ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Value '||l_prev1||' deleted';

Line: 1626


ELSIF l_prev2 IS NOT NULL AND l_mod2 IS NULL THEN l_chg2:= 'Deleted';  l_chgtxt2:= 'Value '||l_prev2||' deleted';

Line: 1651


IF l_chg1 = 'Deleted' OR l_chg2 = 'Deleted' THEN
l_clob := l_clob || '';

Line: 1653


  IF l_chg1 = 'Deleted' THEN
    l_clob := l_clob || ''||l_prev1||'';

Line: 1656


  IF l_chg2 = 'Deleted' THEN
    l_clob := l_clob || ''||l_prev2||'';

Line: 1659


l_clob := l_clob || '';

Line: 1697


ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Value '||l_prev1||' deleted';

Line: 1702


ELSIF l_prev2 IS NOT NULL AND l_mod2 IS NULL THEN l_chg2:= 'Deleted';  l_chgtxt2:= 'Value '||l_prev2||' deleted';

Line: 1707


ELSIF l_prev3 IS NOT NULL AND l_mod3 IS NULL THEN l_chg3:= 'Deleted';  l_chgtxt3:= 'Value '||l_prev3||' deleted';

Line: 1736


IF l_chg1 = 'Deleted' OR l_chg2 = 'Deleted' OR l_chg3 = 'Deleted' THEN
l_clob := l_clob || '';

Line: 1738


  IF l_chg1 = 'Deleted' OR l_chg2 = 'Deleted' THEN
    l_clob := l_clob || '';

Line: 1741


    IF l_chg1 = 'Deleted' THEN
      l_clob := l_clob || '' || l_prev1 || '';

Line: 1744


    IF l_chg2 = 'Deleted' THEN
      l_clob := l_clob || '' || l_prev2 || '';

Line: 1749


  IF l_chg3 = 'Deleted' THEN
      l_clob := l_clob || '' || l_prev3 || '';

Line: 1752


l_clob := l_clob || '';

Line: 1803


ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Value '||l_prev1||' deleted';

Line: 1808


ELSIF l_clob2 IS NOT NULL AND l_clob3 IS NULL THEN l_chg2:= 'Deleted';  l_chgtxt2:= 'Value '||l_prev2||' deleted';

Line: 1837


	SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
			ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
		INTO l_mod1,l_mod2,l_mod3,l_mod4,l_mod5
		FROM po_distributions_all WHERE  po_distribution_id = c.po_dist_id and draft_id = DRAFTID;

Line: 1861


FOR c IN c_deletedObligatedAmounts LOOP
	SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
			ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
		INTO l_mod1,l_mod2,l_mod3,l_mod4,l_mod5
		FROM po_distributions_all WHERE  po_distribution_id = c.po_dist_id and draft_id = -1;

Line: 1867


	l_clob := l_clob || ''||l_mod4||'' ||
			'Accounting Classification Reference Number (ACRN)'||
			l_mod3||'';

Line: 1882


	l_clob := l_clob || '';

Line: 1887


	SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
			ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
		INTO l_mod1,l_mod2,l_mod3,l_mod4,l_mod5
		FROM po_distributions_all WHERE  po_distribution_id = c.po_dist_id and draft_id = DRAFTID;

Line: 1892


	SELECT CLM_MISC_LOA LoaDetails,CLM_AGENCY_ACCT_IDENTIFIER AccountingIdentifier,
			ACRN FinancialCodeValue,round(AMOUNT_FUNDED,5) ObligatedAmount,CODE_COMBINATION_ID code_comb_id
		INTO l_prev1,l_prev2,l_prev3,l_prev4,l_prev5
		FROM po_distributions_all WHERE  po_distribution_id = c.po_dist_id and draft_id = -1;

Line: 1965


ELSIF l_prev1 IS NOT NULL AND l_mod1 IS NULL THEN l_chg1:= 'Deleted'; l_chgtxt1:= 'Value '||l_prev1||' deleted';

Line: 2002


l_sql := 'SELECT EDA FROM PO_EDA_MAPPING WHERE Grouping = ''Common'' AND ATTRIBUTE=''TimeZone'' AND EBS = '''|| l_date ||'''';

Line: 2038


SELECT validation_type
FROM FND_FLEX_VALUE_SETS
WHERE  flex_value_set_id = p_value_set_id;

Line: 2043


SELECT  application_table_name,
        value_column_name,
        id_column_name,
        additional_where_clause
FROM fnd_flex_validation_tables
WHERE flex_value_set_id = p_value_set_id;

Line: 2070


     SELECT distinct var.variable_code
       FROM okc_k_articles_b kart, okc_k_art_variables var
       WHERE kart.document_type=p_doc_type AND kart.document_id=p_doc_id
         and var.cat_id=kart.id AND variable_type='S';

Line: 2076


      SELECT busvar.variable_code
         FROM OKC_BUS_DOC_TYPES_B vo, OKC_BUS_VARIABLES_B busvar
         WHERE vo.document_type=p_doc_type AND busvar.contract_expert_yn='Y'
           AND busvar.variable_intent=vo.intent;

Line: 2081


      SELECT document_type_class
        FROM okc_bus_doc_types_v
        WHERE document_type=p_doc_type;

Line: 2229


					l_sql_stmt :=   'SELECT '||l_name_col||
									' FROM ('||
									' SELECT '||l_name_col||' , '||l_id_col||
									' FROM  '||l_table_name||' ';

Line: 2278


SELECT article_text
FROM okc_article_versions ver, okc_k_articles_b kartb
WHERE kartb.article_version_id = ver.article_version_id
AND   kartb.sav_sae_id = ver.article_id
AND   scn_id = p_scn_id
AND   kartb.document_id = Decode(isMod,'N',DOCUMENTID,DRAFTID);

Line: 2298


select sum(LIST_PRICE_PER_UNIT * QUANTITY )
FROM
po_lines_merge_v pol
WHERE ( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) )
and  nvl(CLM_EXERCISED_FLAG,'N') = 'N'
and   CONTRACT_TYPE = 'FFP';

Line: 2307


select sum(LIST_PRICE_PER_UNIT)
FROM
po_lines_merge_v pol
WHERE ( ( (isMod = 'N')  AND (pol.po_header_id = DOCUMENTID AND pol.draft_id = -1  AND pol.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pol.draft_id = DRAFTID AND pol.change_status IS NOT NULL)) )
and nvl(CLM_EXERCISED_FLAG,'N') = 'N';

Line: 2315


select sum(FUNDED_VALUE)
FROM PO_DISTRIBUTIONS_merge_v  ploc
WHERE
( ( (isMod = 'N')  AND (ploc.po_header_id = DOCUMENTID AND ploc.draft_id = -1  AND ploc.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (ploc.draft_id = DRAFTID AND ploc.change_status is not null) )  )    ;

Line: 2322


SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
                                     p_attr_grp_int_name =>
									 'AMT_'||Decode(pline.contract_type,'AWARD_FEE','AF','COST_PLUS_AWARD_FEE','CPAF')||'_'
									 ||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
									 p_attr_int_name => 'AWARD_FEE'))
FROM po_lines_merge_v pline, po_headers_merge_v phdr
WHERE
( ( (isMod = 'N')  AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1  AND phdr.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) )  )
and
( ( (isMod = 'N')  AND (pline.po_header_id = DOCUMENTID AND pline.draft_id = -1  AND pline.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pline.draft_id = DRAFTID AND pline.change_status is not null) ) )
AND phdr.po_header_id = pline.po_header_id
AND phdr.po_header_id = documentId
AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';

Line: 2339


SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
                                     p_attr_grp_int_name =>
									 'AMT_CPAF_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
                                     p_attr_int_name => 'BASE_FEE'))
FROM po_lines_merge_v pline, po_headers_merge_v phdr
WHERE
( ( (isMod = 'N')  AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1  AND phdr.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) )    )
and
( ( (isMod = 'N')  AND (pline.po_header_id = DOCUMENTID AND pline.draft_id = -1  AND pline.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pline.draft_id = DRAFTID AND pline.change_status is not null) )   )
AND phdr.po_header_id = pline.po_header_id
AND phdr.po_header_id = documentId
AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';

Line: 2355


SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId,
			pk2_value =>  -1,p_attr_grp_int_name => 'AMT_'||
			Decode(pline.contract_type,'FP_INCENTIVE_SUCCESSIVE_TARGET','FIST','FP_INCENTIVE_FIRM_TARGET','FIFT')
			||'_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
                                     p_attr_int_name => 'CEILING_PRICE'))
FROM po_lines_merge_v pline, po_headers_merge_v phdr
WHERE
( ( (isMod = 'N')  AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1  AND phdr.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) )      )
and
( ( (isMod = 'N')  AND (pline.po_header_id = DOCUMENTID AND pline.draft_id = -1  AND pline.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pline.draft_id = DRAFTID AND pline.change_status is not null) )     )
AND phdr.po_header_id = pline.po_header_id
AND phdr.po_header_id = documentId
AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';

Line: 2372


SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
			p_attr_grp_int_name =>  'AMT_'|| Decode(pline.contract_type,'COST_PLUS_FIXED_FEE','CPFF','COST_PLUS_AWARD_FEE','CPAF')||'_'||
									Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
                                     p_attr_int_name => 'ESTIMATED_COST'))
FROM po_lines_merge_v pline, po_headers_merge_v phdr
WHERE
( ( (isMod = 'N')  AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1  AND phdr.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) ))
and
( ( (isMod = 'N')  AND (pline.po_header_id = DOCUMENTID AND pline.draft_id = -1  AND pline.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pline.draft_id = DRAFTID AND pline.change_status is not null) ))
AND phdr.po_header_id = pline.po_header_id
AND phdr.po_header_id = documentId
AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';

Line: 2388


SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
                                     p_attr_grp_int_name => 'AMT_CPFF_'||
									 Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
                                     p_attr_int_name => 'FIXED_FEE'))
FROM po_lines_merge_v pline, po_headers_merge_v phdr
WHERE
( ( (isMod = 'N')  AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1  AND phdr.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) )  )
and
( ( (isMod = 'N')  AND (pline.po_header_id = DOCUMENTID AND pline.draft_id = -1  AND pline.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pline.draft_id = DRAFTID AND pline.change_status is not null) ) )
AND phdr.po_header_id = pline.po_header_id
AND phdr.po_header_id = documentId
AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';

Line: 2404


SELECT Sum(PO_UDA_PUB.get_single_attr_value(p_entity_code => 'PO_LINE_EXT_ATTRS',pk1_value => documentId, pk2_value => -1,
                                     p_attr_grp_int_name => 'AMT_'||Decode(pline.contract_type,'COST_PLUS_INCENTIVE_FEE','CPIF',
									 'FP_INCENTIVE_FIRM_TARGET','FIFT','FP_INCENTIVE_SUCCESSIVE_TARGET','FIST')
									 ||'_'||Decode(phdr.clm_award_type,'IQ','IIQ','REQ','IR','NEG_AGMNT','IN','DQ','IDQ'),
                                     p_attr_int_name => 'TARGET_COST'))
FROM po_lines_merge_v pline, po_headers_merge_v phdr
WHERE
( ( (isMod = 'N')  AND (phdr.po_header_id = DOCUMENTID AND phdr.draft_id = -1  AND phdr.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (phdr.draft_id = DRAFTID AND phdr.change_status is not null) )  )
and
( ( (isMod = 'N')  AND (pline.po_header_id = DOCUMENTID AND pline.draft_id = -1  AND pline.change_status is NULL)) OR
  ( (isMod = 'Y')  AND (pline.draft_id = DRAFTID AND pline.change_status is not null) ) )
AND phdr.po_header_id = pline.po_header_id
AND phdr.po_header_id = documentId
AND Nvl(CLM_EXERCISED_FLAG,'N') = 'N';

Line: 2495


WITH temp AS (SELECT 	ag.attr_group_id gid,
        decode(upper(fcu.end_user_column_name),upper('addressdtlsxml'),efdfce.application_column_name,null) addressxml,
	      decode(upper(fcu.end_user_column_name),upper('addresstype'),efdfce.application_column_name,null) addresstype,
	      decode(upper(fcu.end_user_column_name),upper('contactdtlsxml'),efdfce.application_column_name,null) contacts
      FROM ego_fnd_dsc_flx_ctx_ext ag,
           ego_fnd_df_col_usgs_ext efdfce,
           fnd_descr_flex_column_usages fcu
      WHERE efdfce.descriptive_flexfield_name = ag.descriptive_flexfield_name
      and efdfce.descriptive_flex_context_code  = ag.descriptive_flex_context_code
      and fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
      and fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name
      and fcu.application_column_name = efdfce.application_column_name
      and  ag.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_HEADER_EXT_ATTRS'
      and upper(ag.descriptive_flex_context_code) = upper('addresses')
      and upper(fcu.end_user_column_name) in (upper('addressdtlsxml'),upper('contactdtlsxml'),upper('addresstype')))
      SELECT (SELECT DISTINCT gid FROM temp WHERE gid IS NOT NULL),(SELECT DISTINCT addressxml FROM temp WHERE addressxml IS NOT null),
              (SELECT DISTINCT addresstype FROM temp WHERE addresstype IS NOT NULL),
              (SELECT DISTINCT contacts FROM temp WHERE contacts is NOT NULL)
       into   l_attr_grp_id,
	     l_addr_val_col_name,
	     l_addr_typ_col_name,
	     l_contacts_col_name
      FROM dual;

Line: 2523


		l_sql := 'SELECT ' || l_addr_typ_col_name || ',' || l_addr_val_col_name || ',' || l_contacts_col_name ||
		' FROM po_headers_all_ext_vl WHERE po_header_id = '
		|| p_header_id || ' and draft_id =  ' || p_draft_id ||
		' AND attr_group_id = ' || l_attr_grp_id || 'and ' || l_addr_val_col_name || ' NOT LIKE ''%MOD_ADMIN_OFFICE_ADDR%'' AND '
		|| l_addr_val_col_name || ' NOT LIKE ''%MOD_ISSUING_OFFICE_ADDR%'' AND '
		|| l_addr_typ_col_name || ' NOT IN (SELECT ' || l_addr_typ_col_name || ' FROM po_headers_all_ext_vl WHERE
		po_header_id = ' || p_header_id || ' and draft_id = -1 AND attr_group_id = ' || l_attr_grp_id ||')' ;

Line: 2530


	WHEN 'DELETE' THEN
		l_sql := 'SELECT ' || l_addr_typ_col_name || ',' || l_addr_val_col_name || ',' || l_contacts_col_name  ||
		' FROM po_headers_all_ext_vl WHERE po_header_id = '
		|| p_header_id || ' and draft_id = -1 AND attr_group_id = '
		|| l_attr_grp_id || ' AND ' || l_addr_typ_col_name || ' NOT IN (SELECT ' || l_addr_typ_col_name ||
		' FROM po_headers_all_ext_vl WHERE po_header_id = ' || p_header_id ||
		' and draft_id = ' || p_draft_id || ' AND attr_group_id = ' || l_attr_grp_id || '
		and ' || l_addr_val_col_name || ' NOT LIKE ''%MOD_ADMIN_OFFICE_ADDR%'' AND ' || l_addr_val_col_name ||
		' NOT LIKE ''%MOD_ISSUING_OFFICE_ADDR%'')' ;

Line: 2540


		l_sql := 'SELECT modi.' || l_addr_typ_col_name ||
		',REPLACE(Concat(base.' || l_addr_val_col_name || ',base.' || l_contacts_col_name || ') ,modi.' || l_addr_typ_col_name ||
		',''CUR'')' ||
		',REPLACE(Concat(modi.' || l_addr_val_col_name || ',modi.' || l_contacts_col_name || ') ,modi.' || l_addr_typ_col_name ||
		',''MOD'')' ||
		' FROM po_headers_all_ext_vl base, po_headers_all_ext_vl modi WHERE base.po_header_id = ' || p_header_id ||
		' AND modi.po_header_id = base.po_header_id AND base.draft_id = -1 AND modi.draft_id = ' || p_draft_id ||
		' AND base.attr_group_id = ' || l_attr_grp_id || '
		AND base.attr_group_id = modi.attr_group_id AND modi.' || l_addr_val_col_name || ' NOT LIKE ''%MOD_ADMIN_OFFICE_ADDR%'' AND
		modi.' || l_addr_val_col_name || ' NOT LIKE ''%MOD_ISSUING_OFFICE_ADDR%'' AND base.' || l_addr_typ_col_name || ' = modi.' ||
		l_addr_typ_col_name || '
		AND (base.' || l_addr_val_col_name || ' <> modi.' || l_addr_val_col_name || ' OR base.' || l_contacts_col_name || ' <> modi.' ||
		l_contacts_col_name || ') ' ;

Line: 2595


  select CURRENCY_CODE,RATE
  INTO l_currency , l_exchange
  FROM po_headers_merge_v where po_header_id = DOCUMENTID AND CURRENCY_CODE IS NOT NULL;

Line: 2621


	SELECT MAPPING_FIELD_VALUE_COLUMN
    INTO l_col_name
	  FROM pon_form_section_compiled

	    WHERE form_id =
	 	      (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = 'FED_PRESOL' AND STATUS = 'ACTIVE')
		 AND field_code = 'FED_DESC';

Line: 2629


	l_sql_query :='SELECT '|| l_col_name ||
	' FROM  pon_form_field_values  WHERE OWNING_ENTITY_CODE = ''PON_AUCTION_HEADERS_ALL'' AND ENTITY_PK1 IN (SELECT DISTINCT AUCTION_HEADER_ID FROM po_lines_merge_v WHERE po_header_id = '
	|| DOCUMENTID ||'AND draft_id = '||
	DRAFTID ||') AND FORM_ID = (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = ''FED_PRESOL'' AND STATUS = ''ACTIVE'') ';

Line: 2649


SELECT PO_FBO_PKG.encode_blob(PO_COMM_FPDSNG_PVT.clob_to_blob(to_clob(short_text)))
FROM fnd_documents_short_text
WHERE media_id = p_media_id;

Line: 2654


SELECT PO_FBO_PKG.encode_blob(file_data)
FROM fnd_lobs
WHERE file_id =  p_media_id ;

Line: 2677


  l_sql := 'SELECT '|| p_col_name ||' FROM gl_code_combinations glc WHERE glc.CODE_COMBINATION_ID = ' || p_code_comb_id;

Line: 2684


SELECT DISTINCT
    (CASE SUB_ENTITY_NAME
	    WHEN 'AMT_PRICING' THEN 'Amount Pricing'
	    WHEN 'FILTER_PREDICATE' THEN 'Filter Predicate'
	    WHEN 'ADD_ITEM_INFO' THEN 'Additional Item Information'
	    WHEN 'INSPECT_INFO' THEN 'Inspection Information'
	    WHEN 'CONTRACTOR' THEN 'Contractor'
	    WHEN 'FED_CUST_DESG' THEN 'Federal Customer Designation'
	    WHEN 'LINE_INFO' THEN 'Line Information'
	    WHEN 'CONTRACT' THEN 'Contract'
	    WHEN 'BILLING' THEN 'Billing'
	    WHEN 'ADD_SHIP_INFO' THEN 'Additional Shipping Inforamtion'
	    WHEN 'ORDERING_CONSTRAINTS' THEN 'Ordering constraints'
	    WHEN 'OPTION_INFO' THEN 'Optional Information'
	    WHEN 'QTY_PRICING' THEN 'Quantity Pricing'
	    WHEN 'SOURCE_DOC' THEN 'Sourcing document'
	    ELSE SUB_ENTITY_NAME
    END ) AS entityName
FROM po_entity_differences a,po_diff_config b
WHERE a.ENTITY_NAME IN ('LINE','LINELOCATION','DISTRIBUTION')
AND a.DOCUMENT_TYPE=b.DOCUMENT_TYPE AND a.ENTITY_NAME=b.ENTITY_NAME AND a.MOD_DOC_SOURCE_NAME =b.MOD_DOC_SOURCE_NAME
AND a.COLUMN_NAME=b.COLUMN_NAME
AND MOD_DOC_PK1_VAL  = DOCUMENTID
AND MOD_DOC_PK2_VAL  = DRAFTID
AND MOD_DOC_PK3_VAL  = p_line_id
AND b.SUB_ENTITY_NAME NOT IN ('DELIVERY','SHIP_INFO')  ;

Line: 2732


  l_sql := 'SELECT article_text FROM okc_article_versions WHERE INSERT_BY_REFERENCE <> ''Y'' AND article_version_id=' ||
            p_article_version_id || ' AND article_id = ' ||  p_article_id ;

Line: 2754


    SELECT CLM_CLOSEOUT_STATUS
      INTO v_closeout_indicator
      FROM po_headers_merge_v WHERE
      PO_HEADER_ID = DOCUMENTID AND
      DRAFT_ID = DRAFTID;

Line: 2760


    SELECT A.ATTRVAL
      INTO v_mod_authority
      FROM po_eda_uda_attr_values a WHERE
        a.PK1_VALUE = DOCUMENTID AND
        a.PK2_VALUE = DRAFTID AND
        a.LVL = 'AWARDHEADER' AND
        a.attr = 'mod_Just_mod_auth';

Line: 2776


      SELECT USER_DOCUMENT_STATUS
        INTO v_cancel_indicator
        FROM po_headers_merge_v WHERE
        po_header_id = DOCUMENTID AND draft_id = DRAFTID;

Line: 2783


        SELECT USER_DOCUMENT_STATUS
          INTO v_cancel_indicator
          FROM (
            SELECT USER_DOCUMENT_STATUS, Count(USER_DOCUMENT_STATUS)
              FROM po_lines_merge_v
              WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID
              AND USER_DOCUMENT_STATUS IS NOT NULL
              GROUP BY USER_DOCUMENT_STATUS
              ORDER BY 2) WHERE ROWNUM = 1;

Line: 2796


          SELECT DISTINCT CLM_EXERCISED_FLAG
          INTO v_excersiced_flag
          FROM po_lines_merge_v polMod
          WHERE po_header_id = DOCUMENTID AND draft_id = DRAFTID
          AND CLM_EXERCISED_FLAG = 'Y'
          AND CLM_EXERCISED_FLAG <> (SELECT CLM_EXERCISED_FLAG
                                        FROM po_lines_merge_v polMod
                                        WHERE po_header_id = polMod.po_header_id
                                            AND draft_id = -1  AND po_line_id = polMod.po_line_id);

Line: 2811


          SELECT attrval
          INTO v_duns
          FROM po_eda_uda_attr_values
          WHERE attr = 'SUPPLIER_DTLS_DUNS_NUM'
          AND PK1_VALUE = DOCUMENTID AND PK2_VALUE = DRAFTID
          AND attrval <> (SELECT attrval
                            FROM po_eda_uda_attr_values
                            WHERE attr = 'SUPPLIER_DTLS_DUNS_NUM' AND
                            PK1_VALUE = DOCUMENTID AND PK2_VALUE = -1);

Line: 2826


          SELECT 'Y'
          INTO v_vendor_change_flag
          FROM dual
          WHERE EXISTS (SELECT 1 FROM PO_ENTITY_DIFFERENCES
                          WHERE MOD_DOC_PK1_VAL = DOCUMENTID AND MOD_DOC_PK2_VAL = DRAFTID
                          AND DIFF_ID IN (SELECT DISTINCT DIFF_CONFIG_ID
                                            FROM  po_diff_config
                                            WHERE SUB_ENTITY_NAME = 'SUPPLIER_DTLS'));

Line: 2864


(select distinct RegulationURL from
(SELECT
Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
											   'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
                                               ' '),
						  nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
FROM  okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
WHERE
poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
AND   kartb.sav_sae_id = art.article_id
AND   kartb.article_version_id = ver.article_version_id
AND   art.article_id = ver.article_id
AND   kartb.document_id = p_draftid
AND   kartb.document_type = p_doctype
AND   kartb.document_id = poh.po_header_id
and   kartb.scn_id = scn.id))
minus
(select distinct RegulationURL from
(SELECT
Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
											   'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
                                               ' '),
						  nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
FROM  okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
WHERE
poh.po_header_id = p_docid AND poh.draft_id = -1  AND poh.change_status is NULL
AND   kartb.sav_sae_id = art.article_id
AND   kartb.article_version_id = ver.article_version_id
AND   art.article_id = ver.article_id
AND   kartb.document_id = p_docid
AND   kartb.document_type = SubStr(p_doctype,1,Length(p_doctype)-4)
AND   kartb.document_id = poh.po_header_id
and   kartb.scn_id = scn.id));

Line: 2898


cursor csr_deletedURLs is
(select distinct RegulationURL from
(SELECT
Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
											   'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
                                               ' '),
						  nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
FROM  okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
WHERE
poh.po_header_id = p_docid AND poh.draft_id = -1  AND poh.change_status is NULL
AND   kartb.sav_sae_id = art.article_id
AND   kartb.article_version_id = ver.article_version_id
AND   art.article_id = ver.article_id
AND   kartb.document_id = p_docid
AND   kartb.document_type = SubStr(p_doctype,1,Length(p_doctype)-4)
AND   kartb.document_id = poh.po_header_id
and   kartb.scn_id = scn.id))
minus
(select distinct RegulationURL from
(SELECT
Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
											   'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
                                               ' '),
						  nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
FROM  okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn
WHERE
poh.draft_id = p_draftid AND poh.change_status IS NOT NULL
AND   kartb.sav_sae_id = art.article_id
AND   kartb.article_version_id = ver.article_version_id
AND   art.article_id = ver.article_id
AND   kartb.document_id = p_draftid
AND   kartb.document_type = p_doctype
AND   kartb.document_id = poh.po_header_id
and   kartb.scn_id = scn.id));

Line: 2940


for c in csr_deletedURLs loop
l_clob := l_clob || '' || c.RegulationURL || '';

Line: 2951


select decode(artmod.ARTICLE_TYPE, artorig.ARTICLE_TYPE, NULL, ' Regulation Or Supplement and  Issuing Activity Changed.') CHANGE1,
	   decode(artmod.ARTICLE_NUMBER, artorig.ARTICLE_NUMBER, NULL, ' Clause Number Changed.') CHANGE2,
	   decode(artmod.ARTICLE_TITLE, artorig.ARTICLE_TITLE, NULL, ' Clause Title Changed.') CHANGE3,
	   decode(vermod.START_DATE, verorig.START_DATE, NULL, ' Clause Effective Date Changed.') CHANGE4,
       decode(dbms_lob.compare(vermod.article_text,verorig.article_text),0,NULL,' Clause Text Changed.') CHANGE5
from okc_k_articles_b kartborig, okc_k_articles_b kartbmod, okc_articles_all artorig, okc_articles_all artmod, okc_article_versions verorig,
okc_article_versions vermod
where kartbmod.id = p_kartid
and   kartbmod.orig_system_reference_id1 = kartborig.id
and   artmod.article_id = vermod.article_id
and   artorig.article_id = verorig.article_id
and   kartbmod.article_version_id = vermod.article_version_id
and   kartborig.article_version_id = verorig.article_version_id;

Line: 3004


SELECT VARIABLE_VALUE,VARIABLE_VALUE_ID   FROM okc_k_art_variables WHERE CAT_ID = p_kart_id AND VARIABLE_CODE = p_var_code;

Line: 3008


SELECT sav_sae_id,article_version_id INTO l_article_id,l_article_ver_id FROM okc_k_articles_b WHERE id = p_kart_id;

Line: 3009


SELECT article_text INTO l_clause_text FROM okc_article_versions WHERE article_id = l_article_id AND ARTICLE_VERSION_ID=l_article_ver_id;

Line: 3035


      SELECT FLEX_VALUE INTO l_var_value FROM FND_FLEX_VALUES WHERE FLEX_VALUE_ID = l_var_value_id;

Line: 3069


    SELECT attrval
    INTO l_mod_serial_num
    FROM po_eda_uda_attr_values WHERE
    PK1_VALUE =  p_header_id
    AND PK2_value = p_draft_id
    AND LVL = 'AWARDHEADER'
    AND attr LIKE 'DOD_ORD_MOD_SERIAL_NUMBER';

Line: 3077


    SELECT attrval
    INTO l_mod_type
    FROM po_eda_uda_attr_values WHERE
    PK1_VALUE =  p_header_id
    AND PK2_value = p_draft_id
    AND LVL = 'AWARDHEADER'
    AND attr LIKE 'DOD_ORD_MOD_MODIF_TYPE';

Line: 3091


    SELECT MODIFICATION_NUMBER INTO l_doc_number
    FROM PO_DRAFTS WHERE DRAFT_ID = p_draft_id;

Line: 3099


      SELECT DISPLAYED_FIELD
      INTO l_ord_mod_identifier
      FROM po_lookup_codes
        WHERE lookup_type = l_lookup_constant AND
        LOOKUP_CODE = l_mod_serial_num;

Line: 3119


    SELECT attrval
    INTO l_mod_serial_num
    FROM po_eda_uda_attr_values WHERE
    PK1_VALUE =  p_header_id
    AND PK2_value = p_draft_id
    AND LVL = 'AWARDHEADER'
    AND attr LIKE 'DOD_AWD_MOD_SERIAL_NUMBER';

Line: 3127


    SELECT attrval
    INTO l_mod_type
    FROM po_eda_uda_attr_values WHERE
    PK1_VALUE =  p_header_id
    AND PK2_value = p_draft_id
    AND LVL = 'AWARDHEADER'
    AND attr LIKE 'DOD_AWD_MOD_MODIF_TYPE';

Line: 3141


    SELECT MODIFICATION_NUMBER INTO l_doc_number
    FROM PO_DRAFTS WHERE DRAFT_ID = p_draft_id;