DBA Data[Home] [Help]

APPS.JL_JLZZPSSR_XMLP_PKG dependencies on AP_INVOICES_ALL

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 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 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;