APPS.PO_POXPRCLM_PKG SQL Statements

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

Line: 22

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_requisition_headers_all H,
PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
WHERE H.requisition_header_id = p_req_header_id
AND H.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
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_REQ_HEADERS_EXT_B
                                  where REQUISITION_HEADER_ID = H.requisition_header_id and attr_group_id = POTU.attribute_group_id)

ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 39

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
       AND FCU.DISPLAY_FLAG <> 'H';

Line: 82

      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLAgg(XMLForest(' ;

Line: 85

      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
XMLAgg(XMLForest(';

Line: 90

      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLForest(' ;

Line: 93

      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLForest(';

Line: 159

l_op := ' select XMLConcat(' || l_sql || ') from dual';

Line: 168

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_requisition_lines_all L,
PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
WHERE L.requisition_line_id = p_req_line_id
AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
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_REQ_LINES_EXT_B
                                  where requisition_line_id=p_req_line_id and  attr_group_id = potu.attribute_group_id)
ORDER BY POTU.ATTRIBUTE_GROUP_SEQUENCE;

Line: 184

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
       AND FCU.DISPLAY_FLAG <> 'H';

Line: 227

      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLAgg(XMLForest(' ;

Line: 230

      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '",
XMLAgg(XMLForest(';

Line: 235

      L_SQL := L_SQL || ',' || '(select XMLElement("' || REC.ATTR_GROUP
|| '", XMLForest(' ;

Line: 238

      L_SQL := '(select XMLElement("' || REC.ATTR_GROUP || '", XMLForest(';

Line: 302

l_op := ' select XMLConcat(' || l_sql || ') from dual';