APPS.OE_LIN_SCH SQL Statements

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

Line: 21

        SELECT  SUM( QUANTITY )
        INTO    P_Reserved_Quantity
        FROM    SO_LINE_DETAILS
        WHERE   SCHEDULE_STATUS_CODE = 'RESERVED'
        AND     LINE_ID = P_Line_Id
        AND     NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N';

Line: 59

SELECT  NVL ( SUM ( QUANTITY ) , 0 )
INTO    P_Line_released_Quantity
FROM    SO_LINE_DETAILS
WHERE   LINE_ID = P_Line_Id
AND     NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N'
AND     NVL ( RELEASED_FLAG , 'Y' ) = 'Y'
AND     NVL ( CONFIGURATION_ITEM_FLAG , 'N' ) =
        DECODE ( P_Config_Item_Exists , 'Y' , 'Y' , 'N' );

Line: 100

SELECT COUNT(*)
INTO   Details_Complexity_Count
FROM   SO_LINE_DETAILS
WHERE  LINE_ID = P_Line_Id
AND     NVL ( RELEASED_FLAG , 'N' ) = 'N'
GROUP BY COMPONENT_CODE
HAVING COUNT ( DisTINCT WAREHOUSE_ID ) > 1
OR     COUNT ( DisTINCT SCHEDULE_DATE ) > 1
OR     COUNT ( DisTINCT REVISION ) > 1
OR     COUNT ( DisTINCT LOT_NUMBER ) > 1
OR     COUNT ( DisTINCT SUBINVENTORY ) > 1
OR     COUNT ( DisTINCT DEMAND_CLASS_CODE ) > 1
OR   ( COUNT ( SUBINVENTORY ) > 0
AND    COUNT ( SUBINVENTORY ) <> COUNT ( * ) )
OR   ( COUNT ( WAREHOUSE_ID ) > 0
AND    COUNT ( WAREHOUSE_ID ) <> COUNT ( * ) )
OR   ( COUNT ( SCHEDULE_DATE ) > 0
AND    COUNT ( SCHEDULE_DATE ) <> COUNT ( * ) )
OR   ( COUNT ( LOT_NUMBER ) > 0
AND    COUNT ( LOT_NUMBER ) <> COUNT ( * ) )
OR   ( COUNT ( REVisION ) > 0
AND    COUNT ( REVisION ) <> COUNT ( * ) )
OR   ( COUNT ( DEMAND_CLASS_CODE ) > 0
AND    COUNT ( DEMAND_CLASS_CODE ) <> COUNT ( * ) );

Line: 262

SELECT DECODE( NVL( SUM( DECODE( SCHEDULE_STATUS_CODE,
           'RESERVED', QUANTITY, 0 ) ), 0 ),
       0,
       DECODE( NVL( SUM( DECODE( SCHEDULE_STATUS_CODE,
           'SUPPLY RESERVED', QUANTITY, 0 ) ), 0 ),
       0,
       DECODE( NVL( SUM( DECODE( SCHEDULE_STATUS_CODE,
           'DEMANDED', QUANTITY, 0 ) ), 0 ),
       0, NULL,
       'DEMANDED' ),
       'SUPPLY RESERVED' ),
       'RESERVED' )
	INTO   P_Schedule_Status_Code
	FROM   SO_LINE_DETAILS
	WHERE  LINE_ID = P_Line_Id;

Line: 278

SELECT MEANING
	INTO   P_Schedule_Status_Name
	FROM   SO_LOOKUPS
	WHERE  LOOKUP_TYPE = 'SCHEDULE STATUS'
	AND  LOOKUP_CODE = P_Schedule_Status_Code;

Line: 327

        SELECT      SCHEDULE_DATE
                ,   DEMAND_CLASS_CODE
                ,   SHIP_TO_SITE_USE_ID
                ,   WAREHOUSE_ID
                ,   SHIP_TO_CONTACT_ID
                ,   SHIPMENT_PRIORITY_CODE
                ,   SHIP_METHOD_CODE
                ,   SCHEDULE_DATE_SVRID
                ,   DEMAND_CLASS_SVRID
                ,   SHIP_TO_SVRID
                ,   WAREHOUSE_SVRID
                ,   ORDERED_QUANTITY
                ,   UNIT_CODE
        INTO        P_SCHEDULE_DATE
                ,   P_DEMAND_CLASS_CODE
                ,   P_SHIP_TO_SITE_USE_ID
                ,   P_WAREHOUSE_ID
                ,   P_SHIP_TO_CONTACT_ID
                ,   P_SHIPMENT_PRIORITY_CODE
                ,   P_SHIP_METHOD_CODE
                ,   P_SCHEDULE_DATE_SVRID
                ,   P_DEMAND_CLASS_SVRID
                ,   P_SHIP_TO_SVRID
                ,   P_WAREHOUSE_SVRID
                ,   P_ORDERED_QUANTITY
                ,   P_UNIT_CODE
        FROM    SO_LINES
        WHERE   ROWID = P_Row_id;

Line: 357

        SELECT  SUM ( NVL ( QUANTITY , 0 ) )
        INTO    P_RESERVED_QUANTITY
        FROM    SO_LINE_DETAILS
        WHERE   SCHEDULE_STATUS_CODE = 'RESERVED'
        AND     LINE_ID = P_Line_Id
        AND     NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N';

Line: 609

SELECT  SUM( QUANTITY )
   INTO    P_Reserved_Quantity
   FROM    SO_LINE_DETAILS
   WHERE   SCHEDULE_STATUS_CODE = 'RESERVED'
   AND     LINE_ID = P_Line_Id
   AND     NVL ( INCLUDED_ITEM_FLAG , 'N' ) = 'N';