eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINCTRB_XMLP_PKG dependencies on XLA_AE_LINES

Line 186: LV_GAIN_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'GAIN';

182: FUNCTION CF_RE_AMTFORMULA(ACCTS IN NUMBER
183: ,ORG_ID IN NUMBER
184: ,VENDOR_ID IN NUMBER
185: ,INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER IS
186: LV_GAIN_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'GAIN';
187: LV_LOSS_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'LOSS';
188: LV_ENTITY_CODE XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE := 'AP_INVOICES';
189: CURSOR ALL_INVOICES(ORGN_ID IN NUMBER,VEND_ID IN NUMBER,CURR_CODE IN VARCHAR2) IS
190: SELECT

Line 187: LV_LOSS_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'LOSS';

183: ,ORG_ID IN NUMBER
184: ,VENDOR_ID IN NUMBER
185: ,INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER IS
186: LV_GAIN_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'GAIN';
187: LV_LOSS_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'LOSS';
188: LV_ENTITY_CODE XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE := 'AP_INVOICES';
189: CURSOR ALL_INVOICES(ORGN_ID IN NUMBER,VEND_ID IN NUMBER,CURR_CODE IN VARCHAR2) IS
190: SELECT
191: NVL(SUM(B.AMOUNT)

Line 188: LV_ENTITY_CODE XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE := 'AP_INVOICES';

184: ,VENDOR_ID IN NUMBER
185: ,INVOICE_CURRENCY_CODE IN VARCHAR2) RETURN NUMBER IS
186: LV_GAIN_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'GAIN';
187: LV_LOSS_LINE_TYPE CONSTANT XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE DEFAULT 'LOSS';
188: LV_ENTITY_CODE XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE := 'AP_INVOICES';
189: CURSOR ALL_INVOICES(ORGN_ID IN NUMBER,VEND_ID IN NUMBER,CURR_CODE IN VARCHAR2) IS
190: SELECT
191: NVL(SUM(B.AMOUNT)
192: ,0) AMOUNT,

Line 379: XLA_AE_LINES XAL,

375: AP_INVOICES_ALL A,
376: AP_INVOICE_DISTRIBUTIONS_ALL B,
377: PO_VENDORS POV,
378: PO_VENDOR_SITES_ALL POVS,
379: XLA_AE_LINES XAL,
380: XLA_AE_HEADERS XAH,
381: XLA_TRANSACTION_ENTITIES XTE
382: WHERE A.INVOICE_ID = B.INVOICE_ID
383: AND POV.VENDOR_ID = A.VENDOR_ID