DBA Data[Home] [Help]

APPS.JAI_RCV_TAX_PKG dependencies on OE_ORDER_LINES_ALL

Line 81: v_line_id oe_order_lines_all.line_id % TYPE; --added by GSri and Jagdish on 5-may-01

77: v_paddr RAW(32); /*Bug 4644524 bduvarag*/
78: v_modvat_flag JAI_INV_ITM_SETUPS.modvat_flag % TYPE; --Changed the %type by Nagaraj.s for Bug#2692052
79: v_tax_total NUMBER; --File.Sql.35 Cbabu := 0;
80: -- v_line_id so_lines_all.line_id % type; --commented by GSri and Jagdish on 5-may-01
81: v_line_id oe_order_lines_all.line_id % TYPE; --added by GSri and Jagdish on 5-may-01
82: v_rg_type VARCHAR2(30);
83: v_so_currency oe_order_headers_all.transactional_curr_code % TYPE; -- added
84: v_req_id NUMBER;
85: v_result BOOLEAN;

Line 1854: FROM oe_order_lines_all

1850: --Gsr
1851: ELSIF p_source_document_code = 'RMA' THEN
1852:
1853: FOR rma_rec IN (SELECT order_quantity_uom rma_uom
1854: FROM oe_order_lines_all
1855: WHERE HEADER_ID = p_oe_order_header_id)
1856: LOOP
1857: v_po_uom := rma_rec.rma_uom;
1858: END LOOP;

Line 4179: oe_order_lines_all sla,

4175: spl.unit_code
4176:
4177: FROM
4178:
4179: oe_order_lines_all sla,
4180: oe_order_headers_all sha,
4181: po_requisition_headers_all prha,
4182: po_requisition_lines_all prla,
4183: JAI_OM_WSH_LINES_ALL spl,