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.FV_SF224_TRANSACTIONS dependencies on AP_INVOICES_ALL

Line 33: g_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

29: g_sysdate DATE;
30:
31: g_payment_type_flag ap_checks_all.PAYMENT_TYPE_FLAG%TYPE;
32: g_check_void_date DATE;
33: g_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;
34:
35: sob NUMBER;
36: error_code NUMBER;
37: error_buf VARCHAR2(2000);

Line 1958: ap_invoices_all ai,

1954: gl_code_combinations gcc,
1955: fv_report_definitions frd,
1956: fv_fund_parameters ffp,
1957: fv_treasury_symbols fts,
1958: ap_invoices_all ai,
1959: ap_invoice_distributions_all aid,
1960: ap_invoice_payments_all aip,
1961: ap_payment_hist_dists aphd,
1962: gl_import_references glir,

Line 2071: ap_invoices_all ai,

2067: gl_code_combinations gcc,
2068: fv_report_definitions frd,
2069: fv_fund_parameters ffp,
2070: fv_treasury_symbols fts,
2071: ap_invoices_all ai,
2072: ap_invoice_distributions_all aid,
2073: ap_invoice_payments_all aip,
2074: gl_import_references glir,
2075: xla_ae_headers xah,

Line 3172: FROM ap_invoices_all

3168: -- get the document number
3169: BEGIN
3170: SELECT invoice_num
3171: INTO l_document_number
3172: FROM ap_invoices_all
3173: WHERE invoice_id = TO_NUMBER(l_reference_2);
3174: EXCEPTION WHEN NO_DATA_FOUND THEN
3175: SELECT SUBSTR(name,1,50)
3176: INTO l_document_number

Line 3190: FROM ap_invoices_all

3186: ELSE
3187: BEGIN
3188: SELECT 'Y', invoice_type_lookup_code
3189: INTO l_exists, g_invoice_type_lookup_code
3190: FROM ap_invoices_all
3191: WHERE invoice_id = to_number(l_REFERENCE_2) ;
3192: EXCEPTION
3193: when no_data_found then
3194: x_name := 'Invalid Invoice Id - ' || l_reference_2 ;

Line 3443: from AP_INVOICES_ALL

3439: Else
3440: Begin
3441: select 'Y'
3442: into l_exists
3443: from AP_INVOICES_ALL
3444: Where invoice_id = to_number(l_reference_4);
3445: Exception
3446: when no_data_found then
3447: x_name := 'Invalid Invoice Id - ' || l_reference_4 ;

Line 3955: ap_invoices_all api

3951: l_vendor_id,
3952: l_inv_amount,
3953: l_check_date
3954: FROM ap_checks_all apc,
3955: ap_invoices_all api
3956: WHERE api.invoice_id = NVL(l_reference, 0)
3957: AND apc.check_id = to_number(l_reference_3)
3958: AND l_payables_ia_paygroup = api.pay_group_lookup_code
3959: AND apc.payment_method_lookup_code = 'CLEARING' ;

Line 4031: ap_invoices_all api

4027: apc.void_date
4028: INTO l_accomplish_date,
4029: l_void_date
4030: FROM ap_checks_all apc,
4031: ap_invoices_all api
4032: WHERE api.invoice_id = Nvl(l_reference, 0)
4033: AND apc.check_id = nvl(l_reference_3,0);
4034: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4035: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,

Line 4189: FROM ap_invoices_all

4185: END IF;
4186: -- invoice_id
4187: SELECT invoice_date
4188: INTO l_invoice_date
4189: FROM ap_invoices_all
4190: WHERE Invoice_id = to_number (nvl(l_reference_4,'0')) ;
4191: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4192: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'INVOICE DATE IS '||
4193: TO_CHAR(l_invoice_date, 'MM/DD/YYYY'));

Line 5199: l_parent_invoice_id ap_invoices_all.invoice_id%TYPE;

5195: RETURN DATE IS
5196: l_obligation_date DATE;
5197: l_module_name VARCHAR2(100);
5198: l_po_dist_id ap_invoice_distributions_all.po_distribution_id%TYPE;
5199: l_parent_invoice_id ap_invoices_all.invoice_id%TYPE;
5200: BEGIN
5201: l_module_name := g_module_name || 'get_void_check_obligation_date';
5202: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5203: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Start of get_void_check_obligation_date') ;

Line 5233: FROM ap_invoices_all

5229: END IF;
5230: ELSIF l_parent_invoice_id <> 0 THEN
5231: SELECT INVOICE_DATE
5232: INTO l_obligation_date
5233: FROM ap_invoices_all
5234: WHERE invoice_id = l_parent_invoice_id;
5235: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5236: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
5237: 'Obligation Date is Parent Invoice Date => ' || l_obligation_date);

Line 5242: FROM ap_invoices_all

5238: END IF;
5239: ELSE
5240: SELECT INVOICE_DATE
5241: INTO l_obligation_date
5242: FROM ap_invoices_all
5243: WHERE invoice_id = p_invoice_id;
5244: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5245: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
5246: 'Obligation Date is Invoice Date => ' || l_obligation_date);

Line 5439: FROM ap_invoices_all

5435: DECODE(apid.parent_invoice_id,
5436: NULL,
5437: NULL,
5438: (SELECT invoice_date
5439: FROM ap_invoices_all
5440: WHERE invoice_id = apid.parent_invoice_id)),
5441: (SELECT NVL(gl_encumbered_date,creation_date)
5442: FROM po_distributions
5443: WHERE po_distribution_id = apid.po_distribution_id))

Line 5451: FROM ap_invoices_all

5447: DECODE(apid.parent_invoice_id,
5448: NULL,
5449: NULL,
5450: (SELECT invoice_num
5451: FROM ap_invoices_all
5452: WHERE invoice_id = apid.parent_invoice_id)),
5453: (SELECT segment1
5454: FROM po_headers
5455: WHERE po_header_id = (SELECT po_header_id

Line 5462: ap_invoices_all api,

5458: obligation_number
5459: FROM
5460: ap_checks_all apc,
5461: ap_invoice_payments_all apip,
5462: ap_invoices_all api,
5463: ap_invoice_distributions_all apid
5464: WHERE apip.set_of_books_id = l_set_of_books_id
5465: AND apip.set_of_books_id = api.set_of_books_id
5466: AND api.set_of_books_id = apid.set_of_books_id