APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_LINES

Line 592: ap_invoice_lines L

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
595: AND L.invoice_id = D.invoice_id
596: AND D.posted_flag in ('N', 'P')

Line 636: ap_invoice_lines L,

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
639: AND D.invoice_line_number = L.line_number
640: AND L.invoice_id = D.invoice_id

Line 2271: ap_invoice_lines_all ail,

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
2275: AND ail.invoice_id = aid.invoice_id

Line 2309: ap_invoice_lines_all ail,

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
2313: AND aid.invoice_id = ai.invoice_id

Line 2911: FROM ap_invoice_lines

2907: --bugfix:4674194
2908: SHIP_TO_LOCATION_ID,
2909: --bug 7022001
2910: PAY_AWT_GROUP_ID
2911: FROM ap_invoice_lines
2912: WHERE invoice_id = p_invoice_id
2913: AND line_number = nvl(p_line_number,line_number)
2914: --Invoice Lines: Distributions
2915: ORDER BY decode(line_type_lookup_code,'ITEM',1,2), line_number;

Line 2952: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_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);
2955: l_curr_calling_sequence VARCHAR2(2000);
2956:

Line 2953: l_line_number AP_INVOICE_LINES.LINE_NUMBER%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);
2955: l_curr_calling_sequence VARCHAR2(2000);
2956:
2957: l_api_name VARCHAR2(50);

Line 3009: FROM ap_invoice_lines ail

3005: IF (p_invoice_line_number IS NOT NULL) THEN
3006:
3007: SELECT line_type_lookup_code
3008: INTO l_line_type_lookup_code
3009: FROM ap_invoice_lines ail
3010: WHERE ail.invoice_id = p_invoice_id
3011: AND ail.line_number = p_invoice_line_number;
3012:
3013: IF (l_line_type_lookup_code = 'ITEM') THEN