DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on OE_ORDER_LINES

Line 568: oe_order_lines_all

564: IS
565: SELECT
566: invoicing_rule_id
567: FROM
568: oe_order_lines_all
569: WHERE
570: line_id = p_line_id;
571:
572: l_proc varchar2(72) := g_package||'get_invoice_rule';

Line 877: l_invoice_quantity oe_order_lines.invoiced_quantity%type;

873: p_exist OUT NOCOPY VARCHAR2)
874: IS
875:
876: l_proc varchar2(72) := g_package||'check_invoice';
877: l_invoice_quantity oe_order_lines.invoiced_quantity%type;
878:
879:
880: CURSOR c_invoice IS
881: SELECT

Line 884: oe_order_lines_all

880: CURSOR c_invoice IS
881: SELECT
882: decode(invoiced_quantity,null,0,invoiced_quantity)
883: FROM
884: oe_order_lines_all
885: WHERE
886: line_id = p_line_id;
887:
888: