APPS.CSP_REQUIREMENT_POPULATE_PVT SQL Statements

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

Line: 25

		SELECT p.product_task_id,
		  p.ACTUAL_TIMES_USED
		FROM jtf_tasks_b j,
		  CS_INCIDENTS_ALL_B i,
		  csp_product_tasks p,
		  JTF_TASK_TEMPLATES_B jtt,
		  jtf_task_types_b ttype
		WHERE j.task_id                         = l_task_id
		AND j.SOURCE_OBJECT_TYPE_CODE           = 'SR'
		AND i.incident_id                       = j.SOURCE_OBJECT_ID
		AND p.product_id                        = i.inventory_item_id
		AND p.task_template_id                  = j.template_id
		AND j.template_id                       = jtt.task_template_id
		AND jtt.task_type_id                    = ttype.task_type_id
		AND NVL(ttype.spares_allowed_flag, 'N') = 'Y'
		UNION ALL
		SELECT cpp.product_task_id,
		  cpp.ACTUAL_TIMES_USED
		FROM jtf_tasks_b jtb,
		  csd_repairs cr,
		  csp_product_tasks cpp,
		  JTF_TASK_TEMPLATES_B jtt,
		  jtf_task_types_b ttype
		WHERE jtb.task_id                       = l_task_id
		AND jtb.SOURCE_OBJECT_TYPE_CODE         = 'DR'
		AND cr.repair_line_id                   = jtb.SOURCE_OBJECT_ID
		AND cpp.product_id                      = cr.inventory_item_id
		AND cpp.task_template_id                = jtb.template_id
		AND jtb.template_id                     = jtt.task_template_id
		AND jtt.task_type_id                    = ttype.task_type_id
		AND NVL(ttype.spares_allowed_flag, 'N') = 'Y';

Line: 62

        SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE
        FROM   CSP_TASK_PARTS_V
        WHERE  PRODUCT_TASK_ID = temp_product_task_id;*/

Line: 67

        SELECT INVENTORY_ITEM_ID,PRIMARY_UOM_CODE,QUANTITY,PERCENTAGE,MANUAL_QUANTITY,ROLLUP_QUANTITY,REVISION
        FROM   CSP_TASK_PARTS_V
        WHERE  PRODUCT_TASK_ID = temp_product_task_id
        AND   INVENTORY_ITEM_FLAG = 'Y'
        AND   NVL( trunc(START_DATE),trunc(sysdate)) <= trunc(sysdate)
        AND   NVL( trunc(END_DATE),trunc(sysdate+1)) >= trunc(sysdate);

Line: 142

                        l_requirement_header_rec.LAST_UPDATED_BY  := l_user_id ;

Line: 143

                        l_requirement_header_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 144

                        l_requirement_header_rec.LAST_UPDATE_LOGIN:= l_login_id;

Line: 163

                        select CSP_Requirement_headers_s1.nextval
                        INTO px_header_id
                        FROM DUAL;

Line: 174

                                    l_requirement_line_tbl(count1).LAST_UPDATED_BY         := l_user_id;

Line: 175

                                    l_requirement_line_tbl(count1).LAST_UPDATE_DATE        := SYSDATE ;

Line: 176

                                    l_requirement_line_tbl(count1).LAST_UPDATE_LOGIN       := l_login_id ;

Line: 190

                            l_requirement_line_tbl(count1).LAST_UPDATED_BY         := l_user_id;

Line: 191

                            l_requirement_line_tbl(count1).LAST_UPDATE_DATE        := SYSDATE ;

Line: 192

                            l_requirement_line_tbl(count1).LAST_UPDATE_LOGIN       := l_login_id ;