APPS.OE_PRICE_LIST_PVT SQL Statements

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

Line: 194

	SELECT	/*+ ordered use_nl(OELST OELIN)
                    index(OELST SO_PRICE_LISTS_U1)
                    index(OELIN SO_PRICE_LIST_LINES_N1) */
		OELST.ROUNDING_FACTOR
	,	OELIN.METHOD_CODE
	,	OELIN.LIST_PRICE
	INTO
		l_rounding_factor
	,	l_prc_method_code_out
	,	l_list_price
	FROM	SO_PRICE_LISTS OELST
        ,	SO_PRICE_LIST_LINES OELIN
	WHERE	OELIN.INVENTORY_ITEM_ID = p_inventory_item_id
	AND	OELIN.UNIT_CODE = p_unit_code
	AND	OELIN.METHOD_CODE =
		 NVL( l_prc_method_code, OELIN.METHOD_CODE )
	AND	TRUNC(SYSDATE)
                BETWEEN NVL( OELIN.START_DATE_ACTIVE, TRUNC(SYSDATE) )
		AND     NVL( OELIN.END_DATE_ACTIVE, TRUNC(SYSDATE) )
	AND	NVL( OELIN.PRICING_ATTRIBUTE1, ' ' ) =
		NVL( p_pricing_attribute1, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE2, ' ' ) =
		NVL( p_pricing_attribute2, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE3, ' ' ) =
		NVL( p_pricing_attribute3, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE4, ' ' ) =
		NVL( p_pricing_attribute4, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE5, ' ' ) =
		NVL( p_pricing_attribute5, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE6, ' ' ) =
		NVL( p_pricing_attribute6, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE7, ' ' ) =
		NVL( p_pricing_attribute7, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE8, ' ' ) =
		NVL( p_pricing_attribute8, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE9, ' ' ) =
		NVL( p_pricing_attribute9, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE10, ' ' ) =
		NVL( p_pricing_attribute10, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE11, ' ' ) =
		NVL( p_pricing_attribute11, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE12, ' ' ) =
		NVL( p_pricing_attribute12, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE13, ' ' ) =
		NVL( p_pricing_attribute13, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE14, ' ' ) =
		NVL( p_pricing_attribute14, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE15, ' ' ) =
		NVL( p_pricing_attribute15, ' ' )
	AND	OELST.PRICE_LIST_ID = p_price_list_id
	AND	TRUNC(SYSDATE)
		BETWEEN NVL( OELST.START_DATE_ACTIVE, TRUNC(SYSDATE) )
		AND     NVL( OELST.END_DATE_ACTIVE, TRUNC(SYSDATE) )
	AND	OELST.PRICE_LIST_ID = OELIN.PRICE_LIST_ID
	AND	ROWNUM = 1;

Line: 254

	SELECT	/*+ ordered use_nl(OELST OELIN)
                    index(OELST SO_PRICE_LISTS_U1)
                    index(OELIN SO_PRICE_LIST_LINES_N1) */
		OELST.ROUNDING_FACTOR
	,	OELIN.METHOD_CODE
	,	OELIN.LIST_PRICE
	INTO
		l_rounding_factor
	,	l_prc_method_code_out
	,	l_list_price
	FROM	SO_PRICE_LISTS OELST
        ,	SO_PRICE_LIST_LINES OELIN
	WHERE	OELIN.INVENTORY_ITEM_ID = p_inventory_item_id
	AND	OELIN.UNIT_CODE = p_unit_code
	AND	OELIN.METHOD_CODE =
		 NVL( l_prc_method_code, OELIN.METHOD_CODE )
	AND	TRUNC(SYSDATE)
                BETWEEN NVL( OELIN.START_DATE_ACTIVE, TRUNC(SYSDATE) )
		AND     NVL( OELIN.END_DATE_ACTIVE, TRUNC(SYSDATE) )
	AND	NVL( OELIN.PRICING_ATTRIBUTE1, ' ' ) =
		NVL( p_pricing_attribute1, ' ' )
	AND	OELIN.PRICING_ATTRIBUTE2 = p_pricing_attribute2
	AND	NVL( OELIN.PRICING_ATTRIBUTE3, ' ' ) =
		NVL( p_pricing_attribute3, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE4, ' ' ) =
		NVL( p_pricing_attribute4, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE5, ' ' ) =
		NVL( p_pricing_attribute5, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE6, ' ' ) =
		NVL( p_pricing_attribute6, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE7, ' ' ) =
		NVL( p_pricing_attribute7, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE8, ' ' ) =
		NVL( p_pricing_attribute8, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE9, ' ' ) =
		NVL( p_pricing_attribute9, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE10, ' ' ) =
		NVL( p_pricing_attribute10, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE11, ' ' ) =
		NVL( p_pricing_attribute11, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE12, ' ' ) =
		NVL( p_pricing_attribute12, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE13, ' ' ) =
		NVL( p_pricing_attribute13, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE14, ' ' ) =
		NVL( p_pricing_attribute14, ' ' )
	AND	NVL( OELIN.PRICING_ATTRIBUTE15, ' ' ) =
		NVL( p_pricing_attribute15, ' ' )
	AND	OELST.PRICE_LIST_ID = p_price_list_id
	AND	TRUNC(SYSDATE)
		BETWEEN NVL( OELST.START_DATE_ACTIVE, TRUNC(SYSDATE) )
		AND     NVL( OELST.END_DATE_ACTIVE, TRUNC(SYSDATE) )
	AND	OELST.PRICE_LIST_ID = OELIN.PRICE_LIST_ID
	AND	ROWNUM = 1;

Line: 341

	    --	List percent is the selected list price

	    l_list_percent := l_list_price ;

Line: 498

    END; -- BEGIN select list price block.

Line: 617

    SELECT	SECONDARY_PRICE_LIST_ID
    INTO	l_sec_price_list_id
    FROM	SO_PRICE_LISTS
    WHERE	PRICE_LIST_ID = p_price_list_id;

Line: 648

    SELECT	NAME
    INTO	l_name
    FROM	SO_PRICE_LISTS
    WHERE	PRICE_LIST_ID = p_price_list_id;

Line: 684

    SELECT  DESCRIPTION
    INTO    l_desc
    FROM    MTL_SYSTEM_ITEMS
    WHERE   INVENTORY_ITEM_ID = p_item_id
    AND	    ORGANIZATION_ID = l_org_id;

Line: 717

    SELECT  UNIT_OF_MEASURE
    INTO    l_name
    FROM    MTL_UNITS_OF_MEASURE
    WHERE   UOM_CODE = p_unit_code;