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: 127

      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,
					 WIP_DISCRETE_JOBS DJ,
					 WIP_ENTITIES WE
                                   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
				   AND   DJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
				   AND   DJ.WIP_ENTITY_ID = AD.PK1_VALUE
           			   AND   DJ.WIP_ENTITY_ID = :WIP_Entity_ID';

Line: 151

	P_ITEM_ATTACHMENTS := 'UNION SELECT TO_NUMBER(AD.PK2_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,
					    WIP_DISCRETE_JOBS DJ,
					    WIP_ENTITIES WE
			 	      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 = ''MTL_SYSTEM_ITEMS''
				      AND   AD.PK1_VALUE = :P_ORG_ID
				      AND   DJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
				      AND   DJ.PRIMARY_ITEM_ID = AD.PK2_VALUE
	           		      AND   DJ.WIP_ENTITY_ID = :WIP_Entity_ID';