[Home] [Help]
935: , nvl(header_id, FND_API.G_MISS_NUM)
936: , nvl(line_id, FND_API.G_MISS_NUM)
937: , nvl(trxn_extension_id, FND_API.G_MISS_NUM)
938: , nvl(instrument_security_code,FND_API.G_MISS_CHAR) --R12 CVV2
939: FROM oe_payments_iface_all
940: WHERE order_source_id = l_order_source_id
941: AND orig_sys_document_ref = l_orig_sys_document_ref
942: AND nvl( change_sequence, FND_API.G_MISS_CHAR)
943: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)
1747: , nvl(header_id, FND_API.G_MISS_NUM)
1748: , nvl(line_id, FND_API.G_MISS_NUM)
1749: , nvl(trxn_extension_id, FND_API.G_MISS_NUM)
1750: , nvl(instrument_security_code,FND_API.G_MISS_CHAR) --R12 CVV2
1751: FROM oe_payments_iface_all
1752: WHERE order_source_id = l_order_source_id
1753: AND orig_sys_document_ref = l_orig_sys_document_ref
1754: AND nvl( change_sequence, FND_API.G_MISS_CHAR)
1755: = nvl(l_change_sequence, FND_API.G_MISS_CHAR)