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

Line 425: ap_invoices ai

421: p_inv_enc_type_id
422: FROM ap_system_parameters sp,
423: financials_system_parameters fp,
424: gl_sets_of_books gls,
425: ap_invoices ai
426: WHERE sp.set_of_books_id = gls.set_of_books_id
427: AND sp.set_of_books_id = ai.set_of_books_id
428: AND ai.invoice_id = p_invoice_id;
429:

Line 590: ap_invoices I,

586: NULL, --result_code
587: NULL, --status_code
588: 'N' self_assessed_flag --self_assessed_flag --bug7109594
589: FROM gl_period_statuses PER,
590: ap_invoices I,
591: ap_invoice_distributions_all D,
592: ap_invoice_lines L
593: WHERE D.invoice_id = I.invoice_id
594: AND D.invoice_line_number = L.line_number

Line 634: ap_invoices I,

630: NULL, --result_code
631: NULL, --status_code
632: 'N' self_assessed_flag --self_assessed_flag --bug7109594
633: FROM gl_period_statuses PER,
634: ap_invoices I,
635: ap_invoice_distributions_all D,
636: ap_invoice_lines L,
637: po_distributions_all pod
638: WHERE D.invoice_id = I.invoice_id

Line 672: ap_invoices_all ainv,

668: AND NOT EXISTS ( select 'Advance Exists'
669: from po_distributions_all pod,
670: po_headers_all poh,
671: ap_invoice_distributions_all ainvd,
672: ap_invoices_all ainv,
673: po_doc_style_headers pdsa
674: where pod.po_distribution_id = D.po_distribution_id
675: and poh.po_header_id = pod.po_header_id
676: and poh.style_id = pdsa.style_id

Line 701: ap_invoices I,

697: NULL, --result_code
698: NULL, --status_code
699: T.self_assessed_flag --self_assessed_flag --bug7109594
700: FROM gl_period_statuses PER,
701: ap_invoices I,
702: ap_self_assessed_tax_dist_all T
703: WHERE T.invoice_id = I.invoice_id
704: AND T.posted_flag in ('N', 'P')
705: AND nvl(T.encumbered_flag, 'N') in ('N', 'H', 'P')

Line 741: ap_invoices I,

737: NULL, --result_code
738: NULL, --status_code
739: T.self_assessed_flag --self_assessed_flag --bug7109594
740: FROM gl_period_statuses PER,
741: ap_invoices I,
742: ap_self_assessed_tax_dist_all T
743: WHERE T.invoice_id = I.invoice_id
744: AND T.posted_flag in ('N', 'P')
745: AND nvl(T.encumbered_flag, 'N') in ('N', 'H', 'P')

Line 768: ap_invoices_all ainv,

764: AND NOT EXISTS ( select 'Advance Exists'
765: from po_distributions_all pod,
766: po_headers_all poh,
767: ap_invoice_distributions_all ainvd,
768: ap_invoices_all ainv,
769: po_doc_style_headers pdsa
770: where pod.po_distribution_id = T.po_distribution_id
771: and poh.po_header_id = pod.po_header_id
772: and poh.style_id = pdsa.style_id

Line 846: FROM AP_INVOICES_ALL

842: END IF;
843:
844: SELECT org_id
845: INTO l_org_id
846: FROM AP_INVOICES_ALL
847: WHERE invoice_id = p_invoice_id;
848:
849: IF (Encumbrance_Enabled(l_org_id)) THEN
850:

Line 2270: ap_invoices_all ai,

2266: NULL, --result_code
2267: NULL, --status_code
2268: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2269: FROM ap_invoice_distributions_all aid,
2270: ap_invoices_all ai,
2271: ap_invoice_lines_all ail,
2272: gl_period_statuses per
2273: WHERE ai.invoice_id = p_invoice_id
2274: AND aid.invoice_id = ai.invoice_id

Line 2308: ap_invoices_all ai,

2304: NULL, -- result_code
2305: NULL, -- status_code
2306: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2307: FROM ap_invoice_distributions_all aid,
2308: ap_invoices_all ai,
2309: ap_invoice_lines_all ail,
2310: gl_period_statuses per,
2311: po_distributions_all pod
2312: WHERE ai.invoice_id = p_invoice_id

Line 2340: ap_invoices_all ainv,

2336: AND NOT EXISTS ( select 'Advance Exists'
2337: from po_distributions_all pod,
2338: po_headers_all poh,
2339: ap_invoice_distributions_all ainvd,
2340: ap_invoices_all ainv,
2341: po_doc_style_headers pdsa
2342: where pod.po_distribution_id = aid.po_distribution_id
2343: and poh.po_header_id = pod.po_header_id
2344: and poh.style_id = pdsa.style_id

Line 2369: ap_invoices_all ai,

2365: NULL, --result_code
2366: NULL, --status_code
2367: T.self_assessed_flag --self_assessed_flag --bug7109594
2368: FROM ap_self_assessed_tax_dist_all t,
2369: ap_invoices_all ai,
2370: gl_period_statuses per
2371: WHERE ai.invoice_id = p_invoice_id
2372: AND t.invoice_id = ai.invoice_id
2373: AND (p_inv_line_num IS NULL OR

Line 2403: ap_invoices_all ai,

2399: NULL, -- result_code
2400: NULL, -- status_code
2401: T.self_assessed_flag -- self_assessed_flag --bug7109594
2402: FROM ap_self_assessed_tax_dist_all t,
2403: ap_invoices_all ai,
2404: gl_period_statuses per
2405: WHERE ai.invoice_id = p_invoice_id
2406: AND t.invoice_id = ai.invoice_id
2407: AND (p_inv_line_num IS NULL OR

Line 2424: ap_invoices_all ainv,

2420: AND NOT EXISTS ( select 'Advance Exists'
2421: from po_distributions_all pod,
2422: po_headers_all poh,
2423: ap_invoice_distributions_all ainvd,
2424: ap_invoices_all ainv,
2425: po_doc_style_headers pdsa
2426: where pod.po_distribution_id = t.po_distribution_id
2427: and poh.po_header_id = pod.po_header_id
2428: and poh.style_id = pdsa.style_id

Line 2494: FROM AP_INVOICES_ALL

2490: END IF;
2491:
2492: SELECT org_id
2493: INTO l_org_id
2494: FROM AP_INVOICES_ALL
2495: WHERE invoice_id = p_invoice_id;
2496:
2497:
2498: /*-----------------------------------------------------------------+

Line 2919: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;

2915: ORDER BY decode(line_type_lookup_code,'ITEM',1,2), line_number;
2916:
2917: l_result NUMBER;
2918: l_success BOOLEAN := TRUE;
2919: t_inv_lines_table AP_INVOICES_PKG.t_invoice_lines_table;
2920: i NUMBER;
2921: l_holds AP_APPROVAL_PKG.HOLDSARRAY;
2922: l_hold_count AP_APPROVAL_PKG.COUNTARRAY;
2923: l_release_count AP_APPROVAL_PKG.COUNTARRAY;

Line 2945: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;

2941: l_set_of_books_id NUMBER;
2942: l_error_code VARCHAR2(4000);
2943: l_insufficient_data_exist BOOLEAN := FALSE;
2944: l_batch_id AP_BATCHES.BATCH_ID%TYPE;
2945: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
2946: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2947: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2948: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
2949: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

Line 2946: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;

2942: l_error_code VARCHAR2(4000);
2943: l_insufficient_data_exist BOOLEAN := FALSE;
2944: l_batch_id AP_BATCHES.BATCH_ID%TYPE;
2945: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
2946: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2947: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2948: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
2949: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
2950: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

Line 2947: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;

2943: l_insufficient_data_exist BOOLEAN := FALSE;
2944: l_batch_id AP_BATCHES.BATCH_ID%TYPE;
2945: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
2946: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2947: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2948: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
2949: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
2950: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
2951: l_return_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;

Line 2948: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;

2944: l_batch_id AP_BATCHES.BATCH_ID%TYPE;
2945: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
2946: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2947: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2948: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
2949: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
2950: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
2951: l_return_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2952: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;

Line 2949: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;

2945: l_invoice_date AP_INVOICES.INVOICE_DATE%TYPE;
2946: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2947: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2948: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
2949: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
2950: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
2951: l_return_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2952: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
2953: l_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

Line 2950: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;

2946: l_vendor_id AP_INVOICES.VENDOR_ID%TYPE;
2947: l_invoice_currency_code AP_INVOICES.INVOICE_CURRENCY_CODE%TYPE;
2948: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
2949: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
2950: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
2951: l_return_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2952: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
2953: l_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
2954: l_debug_info VARCHAR2(1000);

Line 2996: FROM ap_invoices

2992: l_invoice_currency_code,
2993: l_exchange_rate,
2994: l_exchange_rate_type,
2995: l_exchange_date
2996: FROM ap_invoices
2997: WHERE invoice_id = p_invoice_id;
2998:
2999: --If the funds check is called for a ITEM line, then
3000: --generate the candidate distributions for just that line,