APPS.AP_RETRO_PRICING_PKG dependencies on AP_INVOICE_LINES_ALL

Line 1271: FROM ap_invoice_lines_all

1267: PRODUCT_TABLE ,
1268: REFERENCE_KEY1 ,
1269: REFERENCE_KEY2 ,
1270: RCV_SHIPMENT_LINE_ID
1271: FROM ap_invoice_lines_all
1272: WHERE invoice_id = p_existing_ppa_inv_id
1273: AND line_source = 'PO PRICE ADJUSTMENT'
1274: AND match_type = 'PO_PRICE_ADJUSTMENT'
1275: AND line_type_lookup_code = 'RETROITEM'

Line 4319: ||'AP_INVOICE_LINES_ALL';

4315: ||P_calling_sequence;
4316:
4317: ---------------------------------------------------------------------------
4318: debug_info := 'Insert_Zero_Amt_Adjustments Step 1. Insert into '
4319: ||'AP_INVOICE_LINES_ALL';
4320: ---------------------------------------------------------------------------
4321:
4322: INSERT INTO AP_INVOICE_LINES_ALL(
4323: invoice_id,

Line 4322: INSERT INTO AP_INVOICE_LINES_ALL(

4318: debug_info := 'Insert_Zero_Amt_Adjustments Step 1. Insert into '
4319: ||'AP_INVOICE_LINES_ALL';
4320: ---------------------------------------------------------------------------
4321:
4322: INSERT INTO AP_INVOICE_LINES_ALL(
4323: invoice_id,
4324: line_number,
4325: line_type_lookup_code,
4326: requester_id,

Line 6158: ||'AP_INVOICE_LINES_ALL ';

6154: p_calling_sequence =>current_calling_sequence);
6155: --
6156: ------------------------------------------------------------------------
6157: debug_info := 'Insert_Ppa_Invoices Step 5. Insert into '
6158: ||'AP_INVOICE_LINES_ALL ';
6159: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
6160: AP_IMPORT_UTILITIES_PKG.Print(
6161: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
6162: END IF;

Line 6169: INSERT INTO AP_INVOICE_LINES_ALL(

6165: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,debug_info);
6166: END IF;
6167:
6168: ------------------------------------------------------------------------
6169: INSERT INTO AP_INVOICE_LINES_ALL(
6170: invoice_id,
6171: line_number,
6172: line_type_lookup_code,
6173: requester_id,

Line 6687: from ap_invoice_lines_all

6683:
6684: -- Bug 5525506
6685: UPDATE ap_invoices_all
6686: set invoice_amount = (select sum(amount)
6687: from ap_invoice_lines_all
6688: where invoice_id = l_ppa_invoice_id)
6689: where invoice_id = l_ppa_invoice_id;
6690: --
6691: END LOOP;

Line 7693: FROM ap_invoice_lines_all ail

7689: LOOP
7690: /*Bug 16450538 Start*/
7691: SELECT NVL(sum(NVL(ail.amount,0)),0)
7692: INTO l_inv_amount
7693: FROM ap_invoice_lines_all ail
7694: WHERE ail.invoice_id = invs.invoice_id
7695: AND line_type_lookup_code ='RETROTAX';
7696:
7697: /*Bug 16450538 End*/

Line 7709: FROM ap_invoice_lines_all prepay

7705: (SELECT
7706: NVL(SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
7707: 'N',
7708: case when exists (SELECT 'Prepay App Exists'
7709: FROM ap_invoice_lines_all prepay
7710: WHERE prepay.invoice_id = zls.trx_id
7711: AND prepay.line_type_lookup_code = 'PREPAY'
7712: AND prepay.prepay_invoice_id = zls.applied_from_trx_id
7713: AND prepay.prepay_line_number = zls.applied_from_line_id