APPS.PO_INVOICES_SV2 dependencies on AP_INVOICE_LINES_INTERFACE

Line 923: from ap_invoice_lines_interface

919: (X_curr_osa_flag <> X_rcv_txns.osa_flag) --Shikyu project
920: THEN
921: /* 2531542 */
922: select count(*) into x_dist_count
923: from ap_invoice_lines_interface
924: where invoice_id = x_curr_invoice_id;
925:
926:
927:

Line 1369: from ap_invoice_lines_interface

1365:
1366: IF (X_curr_inv_process_flag = 'Y') THEN
1367:
1368: select count(*) into x_dist_count
1369: from ap_invoice_lines_interface
1370: where invoice_id = x_curr_invoice_id;
1371:
1372: if (x_dist_count > 0 ) then
1373: BEGIN

Line 1471: from ap_invoice_lines_interface

1467: asn_debug.put_line('Completed create receipt invoices program... ');
1468: END IF;
1469:
1470: select count(*) into x_dist_count
1471: from ap_invoice_lines_interface
1472: where invoice_id = x_curr_invoice_id;
1473:
1474: if (x_dist_count = 0 ) then
1475: x_invoice_count := x_invoice_count - 1;

Line 2509: FROM ap_invoice_lines_interface

2505:
2506:
2507: SELECT NVL(MAX(line_number), 0) + 1
2508: INTO X_line_count
2509: FROM ap_invoice_lines_interface
2510: WHERE invoice_id = x_invoice_id;
2511:
2512: select ap_invoice_lines_interface_s.nextval
2513: into x_invoice_line_id

Line 2512: select ap_invoice_lines_interface_s.nextval

2508: INTO X_line_count
2509: FROM ap_invoice_lines_interface
2510: WHERE invoice_id = x_invoice_id;
2511:
2512: select ap_invoice_lines_interface_s.nextval
2513: into x_invoice_line_id
2514: from sys.dual;
2515:
2516: /* Bug 1374789: We should not pass project_id and task_id

Line 2592: insert into ap_invoice_lines_interface

2588: asn_debug.put_line('x_invoiced_amount: '||x_invoiced_amount);
2589: END IF;
2590: /* PoR with LCM project End */
2591:
2592: insert into ap_invoice_lines_interface
2593: (INVOICE_ID,
2594: INVOICE_LINE_ID,
2595: LINE_NUMBER,
2596: LINE_TYPE_LOOKUP_CODE,

Line 3604: INSERT INTO ap_invoice_lines_interface(

3600: l_ship_to_location_id := get_ship_to_location_id(p_consumption.line_location_id(i));
3601: l_tax_classification_code := get_tax_classification_code(p_consumption.po_header_id(i),
3602: p_consumption.line_location_id(i),
3603: 'PURCHASE_ORDER');
3604: INSERT INTO ap_invoice_lines_interface(
3605: invoice_id,
3606: invoice_line_id,
3607: line_number,
3608: line_type_lookup_code,

Line 3656: ap_invoice_lines_interface_s.nextval,

3652: TAX_CLASSIFICATION_CODE --Bug: 5125624
3653: )
3654: SELECT
3655: p_consumption.invoice_id(i),
3656: ap_invoice_lines_interface_s.nextval,
3657: p_consumption.invoice_line_number(i),
3658: 'ITEM',
3659: p_consumption.invoice_line_amount(i),
3660: -- p_consumption.creation_date(i), -- bug2786193: use sysdate