APPS.WIP_WIPDJDAT_XMLP_PKG SQL Statements

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

Line: 5

  SELECT fifst.id_flex_num
into p_item_flex_num
FROM fnd_id_flex_structures fifst
WHERE fifst.application_id = 401
AND fifst.id_flex_code = 'MSTK'
AND fifst.enabled_flag = 'Y'
AND fifst.freeze_flex_definition_flag = 'Y'
and rownum<2;

Line: 121

      P_FND_ATTACHMENTS := 'UNION SELECT TO_NUMBER(AD.PK1_VALUE),
                                         VL.DESCRIPTION  Instruction,
                                         ST.SHORT_TEXT   Instruction_Description
                                   FROM  FND_DOCUMENTS_SHORT_TEXT ST,
                                         FND_DOCUMENTS D,
                                         FND_DOCUMENTS_VL VL,
                                         FND_ATTACHED_DOCUMENTS AD
                                   WHERE ST.MEDIA_ID = VL.MEDIA_ID
                                   AND   VL.DOCUMENT_ID = AD.DOCUMENT_ID
                                   AND   VL.DOCUMENT_ID = D.DOCUMENT_ID
                                   AND   D.USAGE_TYPE IN (''O'',''T'')
                                   AND   SYSDATE BETWEEN TRUNC(NVL(D.START_DATE_ACTIVE, SYSDATE))
                                         AND TRUNC(NVL(D.END_DATE_ACTIVE, SYSDATE))+1
                                   AND   AD.ENTITY_NAME = ''WIP_DISCRETE_JOBS''
                                   AND   AD.PK2_VALUE = :P_ORG_ID';