DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 142: FROM JAI_OM_WSH_LINES_ALL

138:
139: CURSOR c_ex_inv_no(p_delivery_id varchar2, p_order_line_id varchar2) is
140: SELECT excise_invoice_no , excise_invoice_date,
141: vat_invoice_no, vat_invoice_date --added for bug#6685050
142: FROM JAI_OM_WSH_LINES_ALL
143: WHERE delivery_id = p_delivery_id
144: AND (order_line_id = p_order_line_id
145: /* Added for bug#6391684, Starts */
146: OR order_line_id in (SELECT line_id FROM oe_order_lines_all