DBA Data[Home] [Help]

APPS.WSH_PR_CUSTOM dependencies on SO_LINES_ALL

Line 62: SO_LINES_ALL L

58:
59: SELECT SUM(NVL(L.ORDERED_QUANTITY,0) * NVL(L.SELLING_PRICE,0))
60: INTO order_value
61: FROM SO_HEADERS_ALL H,
62: SO_LINES_ALL L
63: WHERE H.HEADER_ID = p_header_id
64: AND L.HEADER_ID = H.HEADER_ID;
65:
66: RETURN order_value;