APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_LINES

Line 742: ap_invoice_lines L

738: 'N' self_assessed_flag --self_assessed_flag --bug7109594
739: FROM gl_period_statuses PER,
740: ap_invoices I,
741: ap_invoice_distributions_all D,
742: ap_invoice_lines L
743: WHERE D.invoice_id = I.invoice_id
744: AND D.invoice_line_number = L.line_number
745: AND L.invoice_id = D.invoice_id
746: AND D.posted_flag in ('N', 'P')

Line 787: ap_invoice_lines L,

783: 'N' self_assessed_flag --self_assessed_flag --bug7109594
784: FROM gl_period_statuses PER,
785: ap_invoices I,
786: ap_invoice_distributions_all D,
787: ap_invoice_lines L,
788: po_distributions_all pod
789: WHERE D.invoice_id = I.invoice_id
790: AND D.invoice_line_number = L.line_number
791: AND L.invoice_id = D.invoice_id

Line 2676: ap_invoice_lines_all ail,

2672: NULL, --status_code
2673: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2674: FROM ap_invoice_distributions_all aid,
2675: ap_invoices_all ai,
2676: ap_invoice_lines_all ail,
2677: gl_period_statuses per
2678: WHERE ai.invoice_id = p_invoice_id
2679: AND aid.invoice_id = ai.invoice_id
2680: AND ail.invoice_id = aid.invoice_id

Line 2714: ap_invoice_lines_all ail,

2710: NULL, -- status_code
2711: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2712: FROM ap_invoice_distributions_all aid,
2713: ap_invoices_all ai,
2714: ap_invoice_lines_all ail,
2715: gl_period_statuses per,
2716: po_distributions_all pod
2717: WHERE ai.invoice_id = p_invoice_id
2718: AND aid.invoice_id = ai.invoice_id

Line 3332: FROM ap_invoice_lines

3328: --bugfix:4674194
3329: SHIP_TO_LOCATION_ID,
3330: --bug 7022001
3331: PAY_AWT_GROUP_ID
3332: FROM ap_invoice_lines
3333: WHERE invoice_id = p_invoice_id
3334: AND line_number = nvl(p_line_number,line_number)
3335: --Invoice Lines: Distributions
3336: ORDER BY decode(line_type_lookup_code,'ITEM',1,2), line_number;

Line 3373: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;

3369: l_exchange_rate AP_INVOICES.EXCHANGE_RATE%TYPE;
3370: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
3371: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
3372: l_return_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3373: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
3374: l_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
3375: l_debug_info VARCHAR2(1000);
3376: l_curr_calling_sequence VARCHAR2(2000);
3377:

Line 3374: l_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;

3370: l_exchange_rate_type AP_INVOICES.EXCHANGE_RATE_TYPE%TYPE;
3371: l_exchange_date AP_INVOICES.EXCHANGE_DATE%TYPE;
3372: l_return_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
3373: l_line_type_lookup_code AP_INVOICE_LINES.LINE_TYPE_LOOKUP_CODE%TYPE;
3374: l_line_number AP_INVOICE_LINES.LINE_NUMBER%TYPE;
3375: l_debug_info VARCHAR2(1000);
3376: l_curr_calling_sequence VARCHAR2(2000);
3377:
3378: l_api_name VARCHAR2(50);

Line 3430: FROM ap_invoice_lines ail

3426: IF (p_invoice_line_number IS NOT NULL) THEN
3427:
3428: SELECT line_type_lookup_code
3429: INTO l_line_type_lookup_code
3430: FROM ap_invoice_lines ail
3431: WHERE ail.invoice_id = p_invoice_id
3432: AND ail.line_number = p_invoice_line_number;
3433:
3434: IF (l_line_type_lookup_code = 'ITEM') THEN