APPS.JE_JEPLPSSR_XMLP_PKG dependencies on AP_INVOICES

Line 226: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;

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

Line 227: V_INVOICE_DATE AP_INVOICES.INVOICE_NUM%TYPE;

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

Line 228: V_INVOICE_NUM AP_INVOICES.INVOICE_NUM%TYPE;

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

Line 238: AP_INVOICES

234: SELECT
235: INVOICE_DATE,
236: INVOICE_NUM
237: FROM
238: AP_INVOICES
239: WHERE INVOICE_ID = V_INVOICE_ID;
240: CURSOR C_PMT_REL_AWT IS
241: SELECT
242: CHECK_DATE,

Line 337: V_INVOICE_ID AP_INVOICES.INVOICE_ID%TYPE;

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

Line 383: AP_INVOICES AI

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

Line 599: AP_INVOICES_ALL AI

595: NAME
596: INTO L_NAME
597: FROM
598: FND_DOC_SEQUENCE_CATEGORIES FDOC,
599: AP_INVOICES_ALL AI
600: WHERE AI.INVOICE_ID = TRANS_ID
601: AND FDOC.CODE = AI.DOC_CATEGORY_CODE
602: AND FDOC.APPLICATION_ID = 200;
603: RETURN (L_NAME);

Line 668: AP_INVOICES_ALL AI,

664: SELECT
665: SUM(NVL(AID.PREPAY_AMOUNT_REMAINING,AID.AMOUNT)) * - 1
666: INTO L_PREPAY_AMOUNT
667: FROM
668: AP_INVOICES_ALL AI,
669: AP_INVOICE_DISTRIBUTIONS_ALL AID,
670: AP_LOOKUP_CODES ALC
671: WHERE AID.ACCOUNTING_DATE <= P_END_DATE
672: AND AI.INVOICE_TYPE_LOOKUP_CODE = 'PREPAYMENT'