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 941: l_invoice_quantity oe_order_lines.invoiced_quantity%type;

937: p_exist OUT NOCOPY VARCHAR2)
938: IS
939:
940: l_proc varchar2(72) := g_package||'check_invoice';
941: l_invoice_quantity oe_order_lines.invoiced_quantity%type;
942:
943:
944: CURSOR c_invoice IS
945: SELECT

Line 948: oe_order_lines_all

944: CURSOR c_invoice IS
945: SELECT
946: decode(invoiced_quantity,null,0,invoiced_quantity)
947: FROM
948: oe_order_lines_all
949: WHERE
950: line_id = p_line_id;
951:
952: