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.JL_JLZZPSSR_XMLP_PKG dependencies on AP_INVOICES

Line 224: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;

220: END GET_COMPANY_NAME;
221:
222: FUNCTION CF_REF_TRANS_DATEFORMULA(TRANS_TYPE IN VARCHAR2
223: ,TRANS_ID IN NUMBER) RETURN DATE IS
224: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
225: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
226: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
227: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
228: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;

Line 225: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;

221:
222: FUNCTION CF_REF_TRANS_DATEFORMULA(TRANS_TYPE IN VARCHAR2
223: ,TRANS_ID IN NUMBER) RETURN DATE IS
224: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
225: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
226: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
227: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
228: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
229: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;

Line 226: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;

222: FUNCTION CF_REF_TRANS_DATEFORMULA(TRANS_TYPE IN VARCHAR2
223: ,TRANS_ID IN NUMBER) RETURN DATE IS
224: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
225: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;
226: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;
227: V_CHECK_ID AP_CHECKS.CHECK_ID%TYPE;
228: V_CHECK_DATE AP_CHECKS.CHECK_DATE%TYPE;
229: V_CHECK_NUMBER AP_CHECKS.CHECK_NUMBER%TYPE;
230: V_TRANS_TYPE VARCHAR2(25);

Line 236: AP_INVOICES_ALL

232: SELECT
233: INVOICE_DATE,
234: INVOICE_NUM
235: FROM
236: AP_INVOICES_ALL
237: WHERE INVOICE_ID = V_INVOICE_ID;
238: CURSOR C_PMT_REL_AWT IS
239: SELECT
240: CHECK_DATE,

Line 335: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;

331: V_AMOUNT_PAID NUMBER;
332: V_BASE_AMOUNT_PAID NUMBER;
333: V_PMT_AMOUNT NUMBER;
334: V_PMT_BASE_AMOUNT NUMBER;
335: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;
336: V_RATE NUMBER;
337: V_AMOUNT NUMBER;
338: V_PAYMENT_STATUS_FLAG VARCHAR2(1);
339: V_DISC_AMT NUMBER;

Line 381: AP_INVOICES_ALL AI

377: ,0),
378: NVL(EXCHANGE_RATE
379: ,1)
380: FROM
381: AP_INVOICES_ALL AI
382: WHERE AI.INVOICE_ID = V_INVOICE_ID;
383: BEGIN
384: IF TRANS_TYPE = 'INV' THEN
385: V_INVOICE_ID := TRANS_ID;

Line 628: LP_AP_INVOICES_WH := 'AND ai.legal_entity_id = ' || P_REPORTING_CONTEXT;

624: CP_SOB_ID := P_CA_SET_OF_BOOKS_ID;
625: END IF;
626: IF P_REPORTING_LEVEL = '2000' THEN
627: LP_AP_CHECKS_WH := 'AND ac.legal_entity_id = ' || P_REPORTING_CONTEXT;
628: LP_AP_INVOICES_WH := 'AND ai.legal_entity_id = ' || P_REPORTING_CONTEXT;
629: ELSE
630: /*SRW.MESSAGE('124'
631: ,' Not 2000')*/NULL;
632: FND_MO_REPORTING_API.INITIALIZE(P_REPORTING_LEVEL

Line 641: LP_AP_INVOICES_WH := FND_MO_REPORTING_API.GET_PREDICATE('AI'

637: ,P_REPORTING_CONTEXT);
638: LP_AP_CHECKS_WH := FND_MO_REPORTING_API.GET_PREDICATE('AC'
639: ,NULL
640: ,P_REPORTING_CONTEXT);
641: LP_AP_INVOICES_WH := FND_MO_REPORTING_API.GET_PREDICATE('AI'
642: ,NULL
643: ,P_REPORTING_CONTEXT);
644: LP_AP_INVOICE_PAYMENTS_WH := FND_MO_REPORTING_API.GET_PREDICATE('AIP'
645: ,NULL

Line 650: LP_AP_INVOICES := 'AP_INVOICES_ALL';

646: ,P_REPORTING_CONTEXT);
647: END IF;
648: /*SRW.MESSAGE('125'
649: ,'pass param')*/NULL;
650: LP_AP_INVOICES := 'AP_INVOICES_ALL';
651: LP_AP_INVOICE_DISTRIBUTIONS := 'AP_INVOICE_DISTRIBUTIONS_ALL';
652: LP_AP_INVOICE_PAYMENTS := 'AP_INVOICE_PAYMENTS_ALL';
653: /*SRW.MESSAGE('126'
654: ,'pass param 2')*/NULL;