DBA Data[Home] [Help]

APPS.OE_CREDIT_CHECK_ORDER_PVT dependencies on OE_PAYMENT_TYPES_ALL

Line 1432: FROM oe_payment_types_all pt

1428: AND T.TERM_ID = L.PAYMENT_TERM_ID
1429: AND NVL(T.CREDIT_CHECK_FLAG,'N') = 'Y' --bug4888346
1430: AND (EXISTS
1431: (SELECT NULL
1432: FROM oe_payment_types_all pt
1433: WHERE pt.payment_type_code = NVL(l.payment_type_code,
1434: NVL(h.payment_type_code, 'BME'))
1435: AND pt.credit_check_flag = 'Y'
1436: AND NVL(pt.org_id, -99) = NVL(l.org_id,-99))