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.QP_MODIFIERS_ISETUP_IMP SQL Statements

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

Line: 41


                SELECT  KFV.concatenated_segments into item_id
                FROM MTL_SYSTEM_ITEMS_KFV KFV
                WHERE  inventory_item_id = p_product_attr_val
                AND rownum =1;

Line: 51


               select category_name into c_name
               from qp_item_categories_v
               where category_id = p_product_attr_val
               and rownum = 1;

Line: 76


                SELECT  inventory_item_id into item_id
                FROM MTL_SYSTEM_ITEMS_KFV KFV
                WHERE  concatenated_segments = p_product_attr_val
                AND rownum =1;

Line: 86


               select category_id into c_name_id
               from qp_item_categories_v
               where category_name = p_product_attr_val
               and rownum = 1;

Line: 112


       	        SELECT name into item_id
		FROM QP_LIST_HEADERS_TL
		WHERE list_header_id=p_qualifier_attr_val and language='US';

Line: 143


                SELECT list_header_id into item_id
                FROM QP_LIST_HEADERS_TL
                WHERE name=p_qualifier_attr_val and rownum=1;

Line: 208


 SELECT B.attribute1
,      B.attribute10
,      B.attribute11
,      B.attribute12
,      B.attribute13
,      B.attribute14
,      B.attribute15
,      B.attribute2
,      B.attribute3
,      B.attribute4
,      B.attribute5
,      B.attribute6
,      B.attribute7
,      B.attribute8
,      B.attribute9
,      B.automaticflag
,      B.comments
,      B.context
,      B.createdby
,  NULL    creationdate
,      B.currencycode
,      B.discountlinesflag
,      TO_DATE(B.enddateactive,'YYYY-MM-DD HH24:MI:SS')
,      B.freighttermscode
,      B.gsaindicator
,  NULL    lastupdatedby
,  NULL    lastupdatedate
,  NULL    lastupdatelogin
,      B.listheaderid
,      B.listtypecode
,  NULL    programapplicationid
,  NULL    programid
,  NULL    programupdatedate
,      B.prorateflag
,  NULL    requestid
,      TO_NUMBER(B.roundingfactor)
,      B.shipmethodcode
,      TO_DATE(B.startdateactive,'YYYY-MM-DD HH24:MI:SS')
,       RA.term_id
--,      B.TERMSID
,      B.sourcesystemcode
,      B.activeflag
,  FND_API.G_MISS_NUM parentlistheaderid
,      TO_DATE(B.startdateactivefirst,'YYYY-MM-DD HH24:MI:SS')
,      TO_DATE(B.enddateactivefirst,'YYYY-MM-DD HH24:MI:SS')
,      B.activedatefirsttype
,      TO_DATE(B.startdateactivesecond,'YYYY-MM-DD HH24:MI:SS')
,      B.globalflag
,      TO_DATE(B.enddateactivesecond,'YYYY-MM-DD HH24:MI:SS')
,      B.activedatesecondtype
,      B.askforflag
,      B.name
,      B.description
,      B.versionno
, NULL     returnstatus
, NULL     dbflag
, 'CREATE'     operation
,      B.ptecode
,      B.listsourcecode
,      B.origsystemheaderref
,      B.shareableflag
,     FND_API.G_MISS_NUM org_id  -- added org_id for moac
FROM QP_LIST_HEADER_TEMP  B ,
     RA_TERMS_TL           RA
WHERE  B.TERMSNAME = RA.NAME(+)
AND   B.LANGUAGE = RA.LANGUAGE(+)
AND B.VERSIONNO IS NULL
AND
NOT EXISTS  (SELECT 1
                   FROM   QP_LIST_HEADERS_TL TL3
                   WHERE  B.NAME = TL3.NAME
			AND TL3.VERSION_NO IS NULL);

Line: 282


  select LL.arithmeticoperator
 ,   LL.attribute1
 ,   LL.attribute10
 ,   LL.attribute11
 ,   LL.attribute12
 ,   LL.attribute13
 ,   LL.attribute14
 ,   LL.attribute15
 ,   LL.attribute2
 ,   LL.attribute3
 ,   LL.attribute4
 ,   LL.attribute5
 ,   LL.attribute6
 ,   LL.attribute7
 ,   LL.attribute8
 ,   LL.attribute9
 ,   LL.automaticflag
 ,   LL.comments
 ,   LL.context
 ,   LL.createdby
 , null  creationdate
 ,   LL.effectiveperioduom
 ,   TO_DATE(LL.enddateactive,'YYYY-MM-DD HH24:MI:SS')
 ,   TO_NUMBER(LL.estimaccrualrate)
 --,   LL.generateusingformulaid
 ,   TL3.PRICE_FORMULA_ID
 --, FND_API.G_MISS_NUM inventoryitemid
 ,   KFV1.INVENTORY_ITEM_ID
 ,   LL.lastupdatedby
 , null  lastupdatedate
 ,   LL.lastupdatelogin
 , FND_API.G_MISS_NUM  listheaderid
 ,   LL.listlineid
 ,   LL.listlinetypecode
 ,   TO_NUMBER(LL.listprice)
 ,   LL.modifierlevelcode
 ,   TO_NUMBER(LL.numbereffectiveperiods)
 ,   TO_NUMBER(LL.operand)
 --,   LL.organizationid
 ,   MTL.ORGANIZATION_ID
 ,   LL.overrideflag
 ,   TO_NUMBER(LL.percentprice)
 ,   LL.pricebreaktypecode
 --,   LL.pricebyformulaid
 ,   TL2.PRICE_FORMULA_ID
 ,   LL.primaryuomflag
 ,   LL.printoninvoiceflag
 , NULL  programapplicationid
 , NULL  programid
 , null  programupdatedate
 ,   LL.rebatetransactiontypecode
-- , FND_API.G_MISS_NUM  relateditemid
 ,   KFV2.INVENTORY_ITEM_ID
 ,   relationshiptypeid
 ,   LL.repriceflag
 , NULL  requestid
 ,   LL.revision
 ,   TO_DATE(LL.revisiondate,'YYYY-MM-DD HH24:MI:SS')
 ,   LL.revisionreasoncode
 ,   TO_DATE(LL.startdateactive,'YYYY-MM-DD HH24:MI:SS')
 ,   LL.substitutionattribute
 ,   LL.substitutioncontext
 ,   LL.substitutionvalue
 ,   LL.accrualflag
 ,   TO_NUMBER(LL.pricinggroupsequence)
 ,   LL.incompatibilitygrpcode
 ,   LL.listlineno
 ,  FND_API.G_MISS_NUM RltdModifierId
 ,  FND_API.G_MISS_NUM FromRltdModifierId
 ,  FND_API.G_MISS_NUM ToRltdModifierId
 ,  FND_API.G_MISS_NUM RltdModifierGrpNo
 ,  FND_API.G_MISS_CHAR RltdModifierGrpType
 ,   LL.pricingphaseid
 ,   TO_NUMBER(LL.productprecedence)
 ,   TO_DATE(LL.expirationperiodstartdate,'YYYY-MM-DD HH24:MI:SS')
 ,   TO_NUMBER(LL.numberexpirationperiods)
 ,   LL.expirationperioduom
 ,   TO_DATE(LL.expirationdate,'YYYY-MM-DD HH24:MI:SS')
 ,   TO_NUMBER(LL.estimglvalue)
 , FND_API.G_MISS_NUM  benefitpricelistlineid
 ,   TO_NUMBER(LL.benefitlimit)
 ,   LL.chargetypecode
 ,   LL.chargesubtypecode
 ,   TO_NUMBER(LL.benefitqty)
 ,   LL.benefituomcode
 ,   TO_NUMBER(LL.accrualconversionrate)
 ,   LL.prorationtypecode
 ,   LL.includeonreturnsflag
 , null  returnstatus
 , null  dbflag
 , 'CREATE'  operation
 , FND_API.G_MISS_NUM  modifierparentindex
 ,   LL.qualificationind
 ,   LL.netamountflag
 ,   LL.accumattribute
 ,   LL.continuouspricebreakflag
 FROM QP_LIST_LINES_TEMP     LL,
      QP_PRICE_FORMULAS_TL TL2,
      (SELECT concatenated_segments, inventory_item_id
        FROM   MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV1,
      MTL_PARAMETERS       MTL,
      QP_PRICE_FORMULAS_TL TL3,
      (SELECT concatenated_segments, inventory_item_id
       FROM   MTL_SYSTEM_ITEMS_KFV KFV group by concatenated_segments, inventory_item_id) KFV2
 WHERE  LL.LISTHEADERID         = mListHeaderId
 AND LL.PRICEBYFORMULA          = TL2.NAME(+)
 AND LL.LANGUAGE                = TL2.LANGUAGE(+)
 AND LL.ORGANIZATIONCODE        = MTL.ORGANIZATION_CODE(+)
 AND LL.INVENTORYITEMCODE       = KFV1.CONCATENATED_SEGMENTS(+)
 AND LL.relateditemcode         = KFV2.CONCATENATED_SEGMENTS(+)
 AND LL.GENERATEUSINGFORMULA    = TL3.NAME(+)
 AND LL.LANGUAGE                = TL3.LANGUAGE(+);

Line: 397


 select  Q.accumulateflag
,    Q.attribute1
,    Q.attribute10
,    Q.attribute11
,    Q.attribute12
,    Q.attribute13
,    Q.attribute14
,    Q.attribute15
,    Q.attribute2
,    Q.attribute3
,    Q.attribute4
,    Q.attribute5
,    Q.attribute6
,    Q.attribute7
,    Q.attribute8
,    Q.attribute9
,    TO_NUMBER(Q.attributegroupingno)
,    Q.context
,    Q.createdby
,  null creationdate
,    Q.excluderflag
,    Q.lastupdatedby
,  null lastupdatedate
,    Q.lastupdatelogin
,  FND_API.G_MISS_NUM listlineid
,    Q.pricingattribute
,    Q.pricingattributecontext
,  FND_API.G_MISS_NUM pricingattributeid
,    Q.pricingattrvaluefrom
,    Q.pricingattrvalueto
,    Q.productattribute
,    Q.productattributecontext
,    Q.productattrvalue
,    Q.productuomcode
,  null programapplicationid
,  null programid
,  null programupdatedate
,    Q.productattributedatatype
,    Q.pricingattributedatatype
,    Q.comparisonoperatorcode
,  FND_API.G_MISS_NUM listheaderid
--,    Q.pricingphaseid
,    PP.PRICING_PHASE_ID
,  null requestid
,    TO_NUMBER(Q.pricingattrvaluefromnumber)
,    TO_NUMBER(Q.pricingattrvaluetonumber)
,    Q.qualificationind
,  null return_status
,  null db_flag
,  'CREATE' operation
,  1 modifiers_index
FROM
   QP_PRICING_ATTRIBUTES_TEMP Q,
    QP_PRICING_PHASES PP
WHERE  Q.PRICINGPHASENAME = PP.NAME(+)
   AND Q.LISTLINEID = mListLineId;

Line: 456


 SELECT  Q.attribute1
,   Q.attribute10
,   Q.attribute11
,   Q.attribute12
,   Q.attribute13
,   Q.attribute14
,   Q.attribute15
,   Q.attribute2
,   Q.attribute3
,   Q.attribute4
,   Q.attribute5
,   Q.attribute6
,   Q.attribute7
,   Q.attribute8
,   Q.attribute9
,   Q.comparisonoperatorcode
,   Q.context
,   Q.createdby
--,   createdfromruleid
,   QR1.QUALIFIER_RULE_ID
, null  creationdate
--,   TO_DATE(Q.enddateactive,'YYYY-MM-DD HH24:MI:SS')   bug no 5298343
,   Q.enddateactive
,   Q.excluderflag
,   Q.lastupdatedby
, null lastupdatedate
,   Q.lastupdatelogin
,  FND_API.G_MISS_NUM listheaderid
,   Q.listlineid
,   Q.programapplicationid
,   Q.programid
, null  programupdatedate
,   Q.qualifierattribute
,   Q.qualifierattrvalue
,   Q.qualifierattrvalueto
,   Q.qualifiercontext
,   Q.qualifierdatatype
,   TO_NUMBER(Q.qualifiergroupingno)
, FND_API.G_MISS_NUM  qualifierid
,   TO_NUMBER(Q.qualifierprecedence)
--,   qualifierruleid
,  QR2.QUALIFIER_RULE_ID
, NULL  requestid
--,   TO_DATE(Q.startdateactive,'YYYY-MM-DD HH24:MI:SS')     bug no 5298343
,   Q.startdateactive
,   Q.listtypecode
,   TO_NUMBER(Q.qualattrvaluefromnumber)
,   TO_NUMBER(Q.qualattrvaluetonumber)
,   Q.activeflag
,   TO_NUMBER(Q.searchind)
,   TO_NUMBER(Q.qualifiergroupcnt)
,   Q.headerqualsexistflag
,   TO_NUMBER(Q.distinctrowcount)
, null return_status
, NULL db_flag
, 'CREATE' operation
, FND_API.G_MISS_CHAR qualify_hier_descendents_flag
FROM
    QP_QUALIFIERS_TEMP Q,
    QP_QUALIFIER_RULES QR1,
    QP_QUALIFIER_RULES QR2

WHERE  Q.CREATEDFROMRULENAME = QR1.NAME(+)
 AND   Q.QUALIFIERFROMRULENAME = QR2.NAME(+)
 AND   Q.LISTHEADERID = mListHeaderId;

Line: 534


   rows   := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_XML);

Line: 550


   rows   := Dbms_Xmlsave.insertXML(insCtx, P_modifier_list_lines_XML);

Line: 564


   rows   := Dbms_Xmlsave.insertXML(insCtx, P_pricing_attributes_XML);

Line: 578


   rows   := Dbms_Xmlsave.insertXML(insCtx, P_Qualifiers_XML);