DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on RA_TERMS_B

Line 1425: , RA_TERMS_B T

1421: SELECT /* MOAC_SQL_NO_CHANGE */ COUNT(line_id)
1422: INTO l_count
1423: FROM OE_ORDER_LINES_ALL L
1424: , OE_ORDER_HEADERS_ALL H
1425: , RA_TERMS_B T
1426: WHERE h.HEADER_ID = p_header_id
1427: AND L.HEADER_ID = H.HEADER_ID
1428: AND T.TERM_ID = L.PAYMENT_TERM_ID
1429: AND NVL(T.CREDIT_CHECK_FLAG,'N') = 'Y' --bug4888346