APPS.OE_DEFAULT_PVT dependencies on ZX_EXEMPTIONS_V

Line 761: FROM zx_exemptions_v

757: X_Tax_Date DATE,
758: X_Tax_Code VARCHAR2) is
759: --* recheck the joins
760: SELECT tax_exempt_number,tax_exempt_reason_code
761: FROM zx_exemptions_v
762: WHERE site_use_id = NVL(X_Ship_To_Org_Id,X_Invoice_To_Org_id)
763: AND cust_account_id = X_Sold_To_Org_Id
764: --* AND tax_code = X_Tax_Code
765: AND trunc(NVL(X_Tax_Date, SYSDATE)) BETWEEN trunc(effective_from) and

Line 900: FROM ZX_EXEMPTIONS_V

896: SELECT EXEMPT_CERTIFICATE_NUMBER,
897: EXEMPT_REASON_CODE
898: INTO l_tax_exempt_number,
899: l_tax_exempt_reason_code
900: FROM ZX_EXEMPTIONS_V
901: WHERE
902: nvl(site_use_id,nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,
903: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id))
904: = nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,