APPS.WSH_FLEX_PKG_COGS SQL Statements

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

Line: 67

     SELECT nvl(org_id, -99)
     INTO   current_org_id
     FROM   so_headers_all
     WHERE  header_id = X_ORDER_LINE_HEADER_ID;

Line: 183

                                                         TRUE, -- insert if new
				                         X_RETURN_CCID,
				                         X_CONCAT_SEGS,
				                         X_CONCAT_IDS,
				                         X_CONCAT_DESCRS,
				                         X_ERRMSG,
                                                         new_ccid);

Line: 238

              SELECT  NVL(M.COST_OF_SALES_ACCOUNT,0)
	         INTO    L_COST_SALE_ITEM_DERIVED
              FROM    SO_LINE_DETAILS LD,
				  MTL_SYSTEM_ITEMS M
              WHERE   LD.LINE_DETAIL_ID = L_LINE_DETAIL_ID
              AND     M.ORGANIZATION_ID = LD.WAREHOUSE_ID
		    AND     M.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID;

Line: 272

              SELECT   NVL(M.COST_OF_SALES_ACCOUNT,0)
	         INTO     L_COST_SALE_ITEM_DERIVED
              FROM     SO_PICKING_LINE_DETAILS PLD,
				   SO_PICKING_LINES PL,
				   MTL_SYSTEM_ITEMS M
              WHERE    PLD.PICKING_LINE_DETAIL_ID = L_PICK_LINE_DETAIL_ID
              AND      PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
		    AND      M.ORGANIZATION_ID = PLD.WAREHOUSE_ID
		    AND      M.INVENTORY_ITEM_ID = PL.INVENTORY_ITEM_ID;

Line: 308

              SELECT   NVL(M.COST_OF_SALES_ACCOUNT,0)
	         INTO     L_COST_SALE_ITEM_DERIVED
              FROM     SO_LINES L,
				   MTL_SYSTEM_ITEMS M
              WHERE    M.ORGANIZATION_ID = L_ORGANIZATION_ID
              AND      L.LINE_ID = L_ORDER_LINE_ID
		    AND      M.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID;

Line: 400

             SELECT    NVL(M.COST_OF_SALES_ACCOUNT,0)
	        INTO      L_COST_SALE_MODEL_DERIVED
             FROM      SO_LINE_DETAILS LD,
				   MTL_SYSTEM_ITEMS M
             WHERE     LD.LINE_DETAIL_ID = L_LINE_DETAIL_ID
             AND       M.ORGANIZATION_ID = LD.WAREHOUSE_ID
		   AND       M.INVENTORY_ITEM_ID = LD.INVENTORY_ITEM_ID;

Line: 433

             SELECT    NVL(M.COST_OF_SALES_ACCOUNT,0)
	        INTO      L_COST_SALE_MODEL_DERIVED
             FROM      SO_PICKING_LINE_DETAILS PLD,
				   SO_PICKING_LINES PL,
				   MTL_SYSTEM_ITEMS M
             WHERE     PLD.PICKING_LINE_DETAIL_ID = L_PICK_LINE_DETAIL_ID
             AND       PL.PICKING_LINE_ID = PLD.PICKING_LINE_ID
		   AND       M.ORGANIZATION_ID = PLD.WAREHOUSE_ID
		   AND       M.INVENTORY_ITEM_ID = PL.INVENTORY_ITEM_ID;

Line: 469

             SELECT    NVL(M.COST_OF_SALES_ACCOUNT,0)
	        INTO      L_COST_SALE_MODEL_DERIVED
             FROM      SO_LINES L,
				   MTL_SYSTEM_ITEMS M
             WHERE     M.ORGANIZATION_ID = L_ORGANIZATION_ID
             AND       L.LINE_ID = L_ORDER_LINE_ID
		   AND       M.INVENTORY_ITEM_ID = L.INVENTORY_ITEM_ID;

Line: 503

             SELECT NVL(COST_OF_SALES_ACCOUNT,0)
	        INTO   L_COST_SALE_MODEL_DERIVED
             FROM   SO_MODEL_LINE_COGS_ACCOUNT
             WHERE  LINE_ID = L_ORDER_LINE_ID;

Line: 587

	       SELECT    NVL(COST_OF_GOODS_SOLD_ACCOUNT, 0)
	       INTO      L_ORDER_TYPE_CCID
	       FROM      SO_ORDER_TYPES
	       WHERE     ORDER_TYPE_ID = L_ORDER_TYPE_ID;

Line: 666

	       SELECT    NVL(GL_ID_REV, 0)
	       INTO      L_SALESREP_REV_DERIVED
	       FROM      RA_SALESREPS
	       WHERE     SALESREP_ID = L_SALESREP_ID;

Line: 749

	       SELECT    SALESREP_ID
	       INTO      L_SALESREP_ID
	       FROM      SO_LINE_SALES_CREDITS
	       WHERE     LINE_ID = L_ORDER_LINE_ID
	       AND       QUOTA_FLAG = 'Y'
	       AND       SALESREP_ID = (
					   SELECT MIN(SALESREP_ID)
					   FROM SO_LINE_SALES_CREDITS C1
					   WHERE C1.LINE_ID = L_ORDER_LINE_ID
					   AND C1.QUOTA_FLAG = 'Y'
					   AND C1.PERCENT = (
						  SELECT MAX(PERCENT)
						  FROM SO_LINE_SALES_CREDITS C2
						  WHERE C2.LINE_ID = L_ORDER_LINE_ID
						  AND   C2.QUOTA_FLAG = 'Y'
						  AND C2.LEVEL_ID = (
							 SELECT MAX(LEVEL_ID)
							 FROM   SO_LINE_SALES_CREDITS C3
							 WHERE  C3.LINE_ID = L_ORDER_LINE_ID
							 AND    C3.QUOTA_FLAG = 'Y'
										 )
                                              )
                           )
            AND ROWNUM = 1;

Line: 857

	        SELECT    NVL(COST_OF_SALES_ACCOUNT, 0)
	        INTO      L_ACCOUNT_DERIVED
	        FROM      MTL_SYSTEM_ITEMS
	        WHERE     INVENTORY_ITEM_ID = L_INV_ITEM_ID
	        AND       ORGANIZATION_ID = L_ORGANIZATION_ID;

Line: 938

	        SELECT    INVENTORY_ITEM_ID
	        INTO      L_INV_ITEM_ID
	        FROM      SO_LINES
	        WHERE     LINE_ID = L_ORDER_LINE_ID;

Line: 1024

	       SELECT    TYPE.TYPE
	       INTO      L_TRX_TYPE
	       FROM      RA_CUSTOMER_TRX TRX, RA_CUST_TRX_TYPES TYPE
	       WHERE     TRX.CUSTOMER_TRX_ID = L_COMMITMENT_ID
	       AND       TRX.CUST_TRX_TYPE_ID = TYPE.CUST_TRX_TYPE_ID;

Line: 1109

	       SELECT    ORG_ID
	       INTO      L_OPERATING_UNIT
	       FROM      SO_LINES
	       WHERE     LINE_ID = L_ORDER_LINE_ID;

Line: 1189

	       SELECT    PARENT_LINE_ID
	       INTO      L_PARENT_LINE_ID
	       FROM      SO_LINES
	       WHERE     LINE_ID = L_ORDER_LINE_ID;