DBA Data[Home] [Help]

APPS.OE_RMA_QUERY_PRICE dependencies on SO_PRICE_ADJUSTMENTS

Line 21: FROM SO_PRICE_ADJUSTMENTS

17: BEGIN
18:
19: SELECT NVL( SUM( PERCENT ), 0 )
20: INTO L_PRICE_ADJUSTMENTS_TOTAL
21: FROM SO_PRICE_ADJUSTMENTS
22: WHERE (HEADER_ID = P_HEADER_ID
23: AND LINE_ID IS NULL)
24: OR LINE_ID = P_LINE_ID
25: OR (HEADER_ID = P_REF_ORD_HEADER_ID