DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OE_PAYMENTS

Line 294: ,oe_payments pmt

290: ,ordhdr.invoice_to_org_id
291: ,pmt.trxn_extension_id
292: FROM
293: oe_order_headers_all ordhdr
294: ,oe_payments pmt
295: WHERE ordhdr.header_id = c_order_header_id
296: AND ordhdr.header_id = pmt.header_id
297: AND pmt.line_id IS NULL
298: AND pmt.payment_type_code = G_PAYMENT_CREDIT_CARD;

Line 307: ,oe_payments pmt

303: SELECT ordline.invoice_to_org_id
304: ,pmt.trxn_extension_id
305: FROM
306: oe_order_lines_all ordline
307: ,oe_payments pmt
308: WHERE ordline.line_id = c_order_line_id
309: AND ordline.header_id = pmt.header_id
310: AND ordline.line_id = pmt.line_id
311: AND pmt.payment_type_code = G_PAYMENT_CREDIT_CARD;