DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OE_PAYMENTS

Line 254: ,oe_payments pmt

250: ,ordhdr.invoice_to_org_id
251: ,pmt.trxn_extension_id
252: FROM
253: oe_order_headers_all ordhdr
254: ,oe_payments pmt
255: WHERE ordhdr.header_id = c_order_header_id
256: AND ordhdr.header_id = pmt.header_id
257: AND pmt.line_id IS NULL
258: AND pmt.payment_type_code = G_PAYMENT_CREDIT_CARD;

Line 267: ,oe_payments pmt

263: SELECT ordline.invoice_to_org_id
264: ,pmt.trxn_extension_id
265: FROM
266: oe_order_lines_all ordline
267: ,oe_payments pmt
268: WHERE ordline.line_id = c_order_line_id
269: AND ordline.header_id = pmt.header_id
270: AND ordline.line_id = pmt.line_id
271: AND pmt.payment_type_code = G_PAYMENT_CREDIT_CARD;