DBA Data[Home] [Help]

APPS.OZF_OM_PAYMENT_PVT dependencies on OE_ORDER_LINES

Line 454: , oe_order_lines ol

450:
451: CURSOR csr_inv_ord_line_attr(cv_invoice_line_id IN NUMBER) IS
452: SELECT rctl.customer_trx_line_id
453: FROM ra_customer_trx_lines rctl
454: , oe_order_lines ol
455: WHERE rctl.customer_trx_line_id = cv_invoice_line_id
456: AND TO_NUMBER(rctl.interface_line_attribute6) = ol.line_id;
457:
458: CURSOR csr_contact_role(cv_party_id IN NUMBER) IS

Line 483: FROM oe_order_lines_all

479: WHERE salesrep_id = cv_salesrep_id;
480:
481: CURSOR csr_rma_unit_price(cv_line_id IN NUMBER) IS
482: SELECT unit_selling_price
483: FROM oe_order_lines_all
484: WHERE line_id = cv_line_id;
485:
486: CURSOR csr_modifier(cv_list_line_id IN NUMBER) IS
487: SELECT list_header_id