DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 208: FROM JAI_OM_WSH_LINES_ALL

204:
205: CURSOR c_ex_inv_no(p_delivery_id varchar2, p_order_line_id varchar2) is
206: SELECT excise_invoice_no , excise_invoice_date,
207: vat_invoice_no, vat_invoice_date --added for bug#6685050
208: FROM JAI_OM_WSH_LINES_ALL
209: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
210: -- WHERE delivery_id = p_delivery_id
211: WHERE (delivery_id IS NULL OR delivery_id = p_delivery_id)
212: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end

Line 239: lv_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;

235:
236: --add by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168#,begin
237: ----------------------------------------------------------------------------------------------------------------
238: lv_display_flag VARCHAR2(1);
239: lv_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;
240: --------------------------------------------------------------------------------------------------------------
241: --add by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168#,end
242: --Added by Zhiwei for bug#14040855 JAI Trigger elimination begin
243: ---------------------------------------------------------