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 1638: FROM oe_order_lines_all

1634: --Gsr
1635: ELSIF p_source_document_code = 'RMA' THEN
1636:
1637: FOR rma_rec IN (SELECT order_quantity_uom rma_uom
1638: FROM oe_order_lines_all
1639: WHERE HEADER_ID = p_oe_order_header_id)
1640: LOOP
1641: v_po_uom := rma_rec.rma_uom;
1642: END LOOP;

Line 3045: oe_order_lines_all sla,

3041: spl.unit_code
3042:
3043: FROM
3044:
3045: oe_order_lines_all sla,
3046: oe_order_headers_all sha,
3047: po_requisition_headers_all prha,
3048: po_requisition_lines_all prla,
3049: JAI_OM_WSH_LINES_ALL spl,