APPS.JAI_AR_MATCH_TAX_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 268: JAI_OM_WSH_LINES_ALL

264: SELECT
265: excise_invoice_no
266: , vat_invoice_no
267: FROM
268: JAI_OM_WSH_LINES_ALL
269: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
270: -- WHERE delivery_id = p_delivery_id
271: WHERE (--delivery_id IS NULL OR /*commented condition by mmurtuza for bug 16040831*/
272: delivery_id = p_delivery_id)

Line 299: JAI_OM_WSH_LINES_ALL

295: SELECT
296: excise_invoice_no
297: , vat_invoice_no
298: FROM
299: JAI_OM_WSH_LINES_ALL
300: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
301: -- WHERE delivery_id = p_delivery_id
302: WHERE (delivery_id IS NULL)
303: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end

Line 324: lv_vat_invoice_no JAI_OM_WSH_LINES_ALL.Vat_Invoice_No%TYPE;

320: AND (excise_invoice_no IS NOT NULL OR vat_invoice_no IS NOT NULL);
321:
322: ln_delivery_id NUMBER;
323: ln_order_line_id NUMBER;
324: lv_vat_invoice_no JAI_OM_WSH_LINES_ALL.Vat_Invoice_No%TYPE;
325: lv_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;
326: lv_display_flag VARCHAR2(1);
327: ------------------------------------------------------------------------------------------------------------------
328: --Added by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168 ,End

Line 325: lv_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;

321:
322: ln_delivery_id NUMBER;
323: ln_order_line_id NUMBER;
324: lv_vat_invoice_no JAI_OM_WSH_LINES_ALL.Vat_Invoice_No%TYPE;
325: lv_excise_invoice_no JAI_OM_WSH_LINES_ALL.excise_invoice_no%TYPE;
326: lv_display_flag VARCHAR2(1);
327: ------------------------------------------------------------------------------------------------------------------
328: --Added by Bo Li for VAT/Excise Number shown in AR transaction workbench on 19-Jan-2010 and In Bug 9303168 ,End
329: