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

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

Line: 28


     SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
     WHERE template_id = p_template_id;

Line: 32


     SELECT CONTRACT_TYPE FROM po_requisition_lines_all
      WHERE requisition_line_id = p_req_line_id;

Line: 129


     SELECT requisition_line_id FROM po_requisition_lines_all
      WHERE requisition_header_id = p_req_header_id;

Line: 139


     SELECT uda_template_id, preparer_id, org_id
     INTO l_template_id, l_preparer_id, l_org_id
      FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;

Line: 177


           SELECT uda_template_id, line_type_id, contract_type, item_id, deliver_to_location_id
            INTO l_template_id, l_line_type_id, l_contract_line_type, l_item_id, l_deliver_to_location_id
          FROM po_requisition_lines_all
          WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;

Line: 271


        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_REQ_HEADERS_EXT_B
        WHERE   REQUISITION_HEADER_ID = po_rec_header_id;

Line: 276


        SELECT  DISTINCT ATTR_GROUP_ID
        FROM    PO_REQ_LINES_EXT_B
        WHERE   REQUISITION_LINE_ID = po_rec_line_id;

Line: 281


        SELECT  END_USER_COLUMN_NAME
        FROM    FND_DESCR_FLEX_COLUMN_USAGES
        WHERE   DESCRIPTIVE_FLEXFIELD_NAME = p_ag_type
        AND     DESCRIPTIVE_FLEX_CONTEXT_CODE = p_ag_name;

Line: 321


         SELECT ENTITY_CODE
         INTO   l_entity_code
         FROM   PO_UDA_AG_TEMPLATES
         WHERE  TEMPLATE_ID = p_template_id;

Line: 333


                SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                INTO    l_ag_type, l_ag_name
                FROM    EGO_FND_DSC_FLX_CTX_EXT
                WHERE   ATTR_GROUP_ID = c_por_header_ext_rec.ATTR_GROUP_ID;

Line: 385


                SELECT  DESCRIPTIVE_FLEXFIELD_NAME, DESCRIPTIVE_FLEX_CONTEXT_CODE
                INTO    l_ag_type, l_ag_name
                FROM    EGO_FND_DSC_FLX_CTX_EXT
                WHERE   ATTR_GROUP_ID = c_por_line_ext_rec.ATTR_GROUP_ID;

Line: 435


            select o.pk1_column_name,
                   o.pk2_column_name,
                   o.pk3_column_name,
                   o.pk4_column_name,
                   o.pk5_column_name
            into   l_pk1_column_name,
                   l_pk2_column_name,
                   l_pk3_column_name,
                   l_pk4_column_name,
                   l_pk5_column_name
            from   fnd_objects_vl o
            where  o.obj_name = PO_UDA_DATA_UTIL.g_object_dff_tl(l_entity_code).l_object_name;

Line: 596


     SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
     WHERE template_id = p_template_id;

Line: 665


   SELECT requisition_header_id, uda_template_id FROM po_requisition_headers_all
    WHERE conformed_header_id = p_confirmed_id
    AND revision_num = p_revision_num;

Line: 670


    SELECT ATTRIBUTE_GROUP_ID
     FROM po_uda_ag_template_usages WHERE template_id = l_template_id
      AND ATTRIBUTE_CATEGORY = 'ADDRESS';

Line: 698


       SELECT attr_group_name INTO l_attr_group_name
            FROM EGO_ATTR_GROUPS_V
            WHERE  ATTR_GROUP_TYPE =  'PO_REQ_HEADER_EXT_ATTRS' AND ATTR_GROUP_ID = c_get_add_agids_tbl_rec.ATTRIBUTE_GROUP_ID;

Line: 764


   SELECT requisition_header_id FROM po_requisition_headers_all
    WHERE conformed_header_id = p_confirmed_id
    AND   revision_num = p_revision_num;

Line: 780


   SELECT requisition_line_id , conformed_line_id
    BULK COLLECT INTO l_line_ids , l_conformed_line_ids
    FROM po_requisition_lines_all
    WHERE requisition_header_id = l_req_source_hdr_id;

Line: 796


       SELECT uda_template_id INTO l_template_id
        FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_line_ids(i);

Line: 855


   SELECT  uda_template_id FROM po_requisition_headers_all
    WHERE requisition_header_id  = p_from_req_header_id;

Line: 936


   SELECT requisition_line_id
    BULK COLLECT INTO l_from_line_ids
    FROM po_requisition_lines_all
    WHERE requisition_header_id = p_from_req_header_id;

Line: 941


    SELECT requisition_line_id
    BULK COLLECT INTO l_to_line_ids
    FROM po_requisition_lines_all
    WHERE requisition_header_id = p_to_req_header_id;

Line: 955


       SELECT uda_template_id INTO l_template_id
        FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = l_from_line_ids(i);

Line: 1025


     SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
      WHERE template_id = p_template_id
       AND ATTRIBUTE_CATEGORY <> 'DOCUMENT_NUMBERING';

Line: 1030


     SELECT requisition_line_id FROM po_requisition_lines_all
      WHERE requisition_header_id = p_req_header_id;

Line: 1034


     SELECT DISTINCT(ATTRIBUTE_CATEGORY) FROM po_uda_ag_template_usages
     WHERE template_id = p_template_id;

Line: 1038


     SELECT CONTRACT_TYPE FROM po_requisition_lines_all
      WHERE requisition_line_id = p_req_line_id;

Line: 1048


   SELECT uda_template_id INTO l_template_id
    FROM po_requisition_headers_all WHERE requisition_header_id = p_req_header_id;

Line: 1073


     SELECT preparer_id, org_id INTO l_preparer_id, l_org_id
     FROM po_requisition_headers_all
     WHERE requisition_header_id = p_req_header_id;

Line: 1098


          SELECT uda_template_id INTO l_template_id
          FROM po_requisition_lines_all
          WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;

Line: 1125


              SELECT line_type_id, contract_type, item_id, deliver_to_location_id
            INTO l_line_type_id, l_contract_line_type, l_item_id, l_deliver_to_location_id
            FROM po_requisition_lines_all
            WHERE requisition_line_id = c_get_lines_rec.requisition_line_id;

Line: 1182


    SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
    FROM   PO_REQ_HEADERS_EXT_B
    WHERE  REQUISITION_HEADER_ID = p_old_header_id
	AND  ATTR_GROUP_ID in ( SELECT   ATTR_GROUP_ID    FROM
        PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
        WHERE usages.template_id = p_template_id
              AND usages.ATTRIBUTE1='Base Document'
              AND usages.ATTRIBUTE2='NA'
              AND usages.ATTRIBUTE_CATEGORY='DOCUMENT_NUMBERING'
              AND usages.attribute_group_id = ags.attr_group_id);

Line: 1208


insert into  PO_REQ_HEADERS_EXT_B(
 extension_id
,attr_group_id
,requisition_header_id
,data_level_id
,pk1_value
,pk2_value
,pk3_value
,pk4_value
,pk5_value
,last_update_date
,last_updated_by
,last_update_login
,created_by
,creation_date
,c_ext_attr1
,c_ext_attr2
,c_ext_attr3
,c_ext_attr4
,c_ext_attr5
,c_ext_attr6
,c_ext_attr7
,c_ext_attr8
,c_ext_attr9
,c_ext_attr10
,c_ext_attr11
,c_ext_attr12
,c_ext_attr13
,c_ext_attr14
,c_ext_attr15
,c_ext_attr16
,c_ext_attr17
,c_ext_attr18
,c_ext_attr19
,c_ext_attr20
,c_ext_attr21
,c_ext_attr22
,c_ext_attr23
,c_ext_attr24
,c_ext_attr25
,c_ext_attr26
,c_ext_attr27
,c_ext_attr28
,c_ext_attr29
,c_ext_attr30
,c_ext_attr31
,c_ext_attr32
,c_ext_attr33
,c_ext_attr34
,c_ext_attr35
,c_ext_attr36
,c_ext_attr37
,c_ext_attr38
,c_ext_attr39
,c_ext_attr40
,n_ext_attr1
,n_ext_attr2
,n_ext_attr3
,n_ext_attr4
,n_ext_attr5
,n_ext_attr6
,n_ext_attr7
,n_ext_attr8
,n_ext_attr9
,n_ext_attr10
,n_ext_attr11
,n_ext_attr12
,n_ext_attr13
,n_ext_attr14
,n_ext_attr15
,n_ext_attr16
,n_ext_attr17
,n_ext_attr18
,n_ext_attr19
,n_ext_attr20
,uom_ext_attr1
,uom_ext_attr2
,uom_ext_attr3
,uom_ext_attr4
,uom_ext_attr5
,uom_ext_attr6
,uom_ext_attr7
,uom_ext_attr8
,uom_ext_attr9
,uom_ext_attr10
,uom_ext_attr11
,uom_ext_attr12
,uom_ext_attr13
,uom_ext_attr14
,uom_ext_attr15
,uom_ext_attr16
,uom_ext_attr17
,uom_ext_attr18
,uom_ext_attr19
,uom_ext_attr20
,d_ext_attr1
,d_ext_attr2
,d_ext_attr3
,d_ext_attr4
,d_ext_attr5
,d_ext_attr6
,d_ext_attr7
,d_ext_attr8
,d_ext_attr9
,d_ext_attr10
,uda_template_id
)

select
l_new_hdr_ext_id
,attr_group_id
,p_new_header_id
,data_level_id
,pk1_value
,pk2_value
,pk3_value
,pk4_value
,pk5_value
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.login_id
,FND_GLOBAL.user_id
,SYSDATE
,c_ext_attr1
,c_ext_attr2
,c_ext_attr3
,c_ext_attr4
,c_ext_attr5
,c_ext_attr6
,c_ext_attr7
,c_ext_attr8
,c_ext_attr9
,c_ext_attr10
,c_ext_attr11
,c_ext_attr12
,c_ext_attr13
,c_ext_attr14
,c_ext_attr15
,c_ext_attr16
,c_ext_attr17
,c_ext_attr18
,c_ext_attr19
,c_ext_attr20
,c_ext_attr21
,c_ext_attr22
,c_ext_attr23
,c_ext_attr24
,c_ext_attr25
,c_ext_attr26
,c_ext_attr27
,c_ext_attr28
,c_ext_attr29
,c_ext_attr30
,c_ext_attr31
,c_ext_attr32
,c_ext_attr33
,c_ext_attr34
,c_ext_attr35
,c_ext_attr36
,c_ext_attr37
,c_ext_attr38
,c_ext_attr39
,'##'||c_ext_attr40
,n_ext_attr1
,n_ext_attr2
,n_ext_attr3
,n_ext_attr4
,n_ext_attr5
,n_ext_attr6
,n_ext_attr7
,n_ext_attr8
,n_ext_attr9
,n_ext_attr10
,n_ext_attr11
,n_ext_attr12
,n_ext_attr13
,n_ext_attr14
,n_ext_attr15
,n_ext_attr16
,n_ext_attr17
,n_ext_attr18
,n_ext_attr19
,n_ext_attr20
,uom_ext_attr1
,uom_ext_attr2
,uom_ext_attr3
,uom_ext_attr4
,uom_ext_attr5
,uom_ext_attr6
,uom_ext_attr7
,uom_ext_attr8
,uom_ext_attr9
,uom_ext_attr10
,uom_ext_attr11
,uom_ext_attr12
,uom_ext_attr13
,uom_ext_attr14
,uom_ext_attr15
,uom_ext_attr16
,uom_ext_attr17
,uom_ext_attr18
,uom_ext_attr19
,uom_ext_attr20
,d_ext_attr1
,d_ext_attr2
,d_ext_attr3
,d_ext_attr4
,d_ext_attr5
,d_ext_attr6
,d_ext_attr7
,d_ext_attr8
,d_ext_attr9
,d_ext_attr10
,p_template_id
from PO_REQ_HEADERS_EXT_B where  extension_id = l_old_hdr_ext_id;

Line: 1427


insert into PO_req_HEADERS_EXT_TL(
extension_id
,attr_group_id
,requisition_header_id
,data_level_id
,pk1_value
,pk2_value
,pk3_value
,pk4_value
,pk5_value
,source_lang
,LANGUAGE
,last_update_date
,last_updated_by
,last_update_login
,created_by
,creation_date
,tl_ext_attr1
,tl_ext_attr2
,tl_ext_attr3
,tl_ext_attr4
,tl_ext_attr5
,tl_ext_attr6
,tl_ext_attr7
,tl_ext_attr8
,tl_ext_attr9
,tl_ext_attr10
,tl_ext_attr11
,tl_ext_attr12
,tl_ext_attr13
,tl_ext_attr14
,tl_ext_attr15
,tl_ext_attr16
,tl_ext_attr17
,tl_ext_attr18
,tl_ext_attr19
,tl_ext_attr20
,tl_ext_attr21
,tl_ext_attr22
,tl_ext_attr23
,tl_ext_attr24
,tl_ext_attr25
,tl_ext_attr26
,tl_ext_attr27
,tl_ext_attr28
,tl_ext_attr29
,tl_ext_attr30
,tl_ext_attr31
,tl_ext_attr32
,tl_ext_attr33
,tl_ext_attr34
,tl_ext_attr35
,tl_ext_attr36
,tl_ext_attr37
,tl_ext_attr38
,tl_ext_attr39
,tl_ext_attr40
,uda_template_id
)

select
l_new_hdr_ext_id
,attr_group_id
,p_new_header_id
,data_level_id
,pk1_value
,pk2_value
,pk3_value
,pk4_value
,pk5_value
,source_lang
,LANGUAGE
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.login_id
,FND_GLOBAL.user_id
,SYSDATE
,tl_ext_attr1
,tl_ext_attr2
,tl_ext_attr3
,tl_ext_attr4
,tl_ext_attr5
,tl_ext_attr6
,tl_ext_attr7
,tl_ext_attr8
,tl_ext_attr9
,tl_ext_attr10
,tl_ext_attr11
,tl_ext_attr12
,tl_ext_attr13
,tl_ext_attr14
,tl_ext_attr15
,tl_ext_attr16
,tl_ext_attr17
,tl_ext_attr18
,tl_ext_attr19
,tl_ext_attr20
,tl_ext_attr21
,tl_ext_attr22
,tl_ext_attr23
,tl_ext_attr24
,tl_ext_attr25
,tl_ext_attr26
,tl_ext_attr27
,tl_ext_attr28
,tl_ext_attr29
,tl_ext_attr30
,tl_ext_attr31
,tl_ext_attr32
,tl_ext_attr33
,tl_ext_attr34
,tl_ext_attr35
,tl_ext_attr36
,tl_ext_attr37
,tl_ext_attr38
,tl_ext_attr39
,tl_ext_attr40
,p_template_id

from PO_req_HEADERS_EXT_TL  where  extension_id = l_old_hdr_ext_id;