APPS.OEXVWCAN SQL Statements

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

Line: 24

         SELECT SHIPMENT_SCHEDULE_LINE_ID,
		PARENT_LINE_ID,
		LINE_NUMBER
         INTO   V_SHIPMENT_SCHEDULE_LINE_ID,
		V_PARENT_LINE_ID,
		V_LINE_NUMBER
         FROM   SO_LINES
         WHERE  LINE_ID = P_SERVICE_PARENT_LINE_ID;

Line: 37

        	SELECT	LINE_NUMBER
        	INTO	SCHEDULE_LINE_NUMBER
		FROM	SO_LINES
		WHERE	LINE_ID = V_PARENT_LINE_ID;

Line: 73

         SELECT SHIPMENT_SCHEDULE_LINE_ID,
                PARENT_LINE_ID,
                LINE_NUMBER
         INTO   V_SHIPMENT_SCHEDULE_LINE_ID,
                V_PARENT_LINE_ID,
                V_LINE_NUMBER
         FROM   SO_LINES
         WHERE  LINE_ID = P_SERVICE_PARENT_LINE_ID;

Line: 86

		SELECT  LINE_NUMBER
	        INTO    BASE_LINE_NUMBER
		FROM    SO_LINES
		WHERE   LINE_ID = V_PARENT_LINE_ID;

Line: 92

	SELECT	LINE_NUMBER
	INTO	BASE_LINE_NUMBER
	FROM	SO_LINES
	WHERE	LINE_ID = V_SHIPMENT_SCHEDULE_LINE_ID;

Line: 126

         SELECT SHIPMENT_SCHEDULE_LINE_ID,
		PARENT_LINE_ID,
		LINE_NUMBER
         INTO   V_SHIPMENT_SCHEDULE_LINE_ID,
		V_PARENT_LINE_ID,
		V_LINE_NUMBER
         FROM   SO_LINES
         WHERE  LINE_ID = P_SERVICE_PARENT_LINE_ID;

Line: 166

	SELECT	'Y'
	INTO	V_SUBTREE_EXISTS
	FROM	SO_LINES
	WHERE	LINK_TO_LINE_ID = V_LINE_ID
	AND	PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
	AND	ITEM_TYPE_CODE <> 'SERVICE'
	AND	LINE_TYPE_CODE <> 'RETURN'
	AND     ROWNUM = 1;

Line: 213

				SELECT ITEM_TYPE_CODE
				INTO TEMP_ITEM_TYPE_CODE
				FROM SO_LINES
				WHERE LINE_ID = V_SERVICE_PARENT_LINE_ID;

Line: 251

	SELECT	'Y'
	INTO 	V_OPEN_PICKING_SLIPS
	FROM 	SO_PICKING_LINES SOL,
		SO_PICKING_HEADERS SPH
	WHERE 	SOL.PICKING_HEADER_ID = SPH.PICKING_HEADER_ID
	AND 	SOL.ORDER_LINE_ID in
		(SELECT	LINE_ID
		FROM	SO_LINES
		WHERE 	PARENT_LINE_ID = V_REAL_PARENT_LINE_ID
		AND	NVL(COMPONENT_CODE,'0') LIKE V_COMPONENT_CODE || '%'
		AND	V_SUBTREE_EXISTS = 'Y'
		UNION
		SELECT	LINE_ID
		FROM	SO_LINES
		WHERE	LINE_ID = V_LINE_ID)
	AND 	SPH.STATUS_CODE IN ('OPEN' ,'PENDING', 'IN PROGRESS')
        AND     ROWNUM = 1;

Line: 288

	SELECT 	COUNT(0)
	INTO	V_PRICE_ADJUST_COUNT
	FROM 	SO_PRICE_ADJUSTMENTS PA,
		SO_DISCOUNT_LINES DL
	WHERE 	PA.HEADER_ID = V_HEADER_ID
	AND   	PA.LINE_ID = V_LINE_ID
	AND   	PA.DISCOUNT_LINE_ID = DL.DISCOUNT_LINE_ID
	AND   	DL.PERCENT IS NULL
	AND  	DL.AMOUNT IS NULL
	AND  	DL.PRICE IS NULL;

Line: 320

	SELECT COMPONENT_SEQUENCE_ID
	INTO   V_TOP_BILL_SEQUENCE_ID
	FROM   SO_LINES
	WHERE  LINE_ID = NVL(V_PARENT_LINE_ID,V_LINE_ID);