[Home] [Help]
277: /* Bug9967535 ends*/
278:
279:
280: -- Procedure will Insert distributions tarcked as asset in
281: -- FA_MASS_ADDITIONS_GT table
282: --
283: PROCEDURE Insert_Mass(
284: P_acctg_date IN DATE,
285: P_ledger_id IN NUMBER,
582: AND satx.set_of_books_id = P_ledger_id
583: AND (satx.asset_book_type_code = P_bt_code OR
584: satx.asset_book_type_code IS NULL);
585:
586: INSERT INTO FA_MASS_ADDITIONS_GT(
587: mass_addition_id,
588: asset_number,
589: tag_number,
590: description,
1082: AND satx.set_of_books_id = P_ledger_id
1083: AND (satx.asset_book_type_code = P_bt_code OR
1084: satx.asset_book_type_code IS NULL);
1085:
1086: INSERT INTO FA_MASS_ADDITIONS_GT(
1087: mass_addition_id,
1088: asset_number,
1089: tag_number,
1090: description,
1402: FROM ap_invoice_distributions_gt APIDG
1403: where charge_applicable_to_dist_id is null
1404: AND NOT EXISTS
1405: (SELECT 1
1406: FROM fa_mass_additions_gt FAGT
1407: WHERE APIDG.INVOICE_DISTRIBUTION_ID = FAGT.INVOICE_DISTRIBUTION_ID
1408: )
1409: );
1410: /* Modified the query for performance bug 8729684: end */
1421: WHERE
1422: CHARGE_APPLICABLE_TO_DIST_ID IS NOT NULL
1423: AND NOT EXISTS
1424: (
1425: SELECT 1 FROM FA_MASS_ADDITIONS_GT FAGT
1426: where APIDG.INVOICE_DISTRIBUTION_ID=FAGT.INVOICE_DISTRIBUTION_ID
1427: )
1428: )
1429: AND EXISTS
1443: (SELECT APIDG.invoice_distribution_id
1444: FROM ap_invoice_distributions_gt APIDG)
1445: AND AID.invoice_distribution_id NOT IN
1446: (SELECT FAGT.invoice_distribution_id
1447: FROM fa_mass_additions_gt FAGT)
1448: -- bug 7215835: add end
1449: -- bug 8690407: add start
1450: and exists (select 1 from ap_invoice_distributions_all
1451: where invoice_distribution_id = aid.charge_applicable_to_dist_id
1472: END Insert_Mass;
1473:
1474: ----------------------------------------------------------------------------
1475: -- Procedure will Insert Discount related to distributions that are tracked
1476: -- as asset in FA_MASS_ADDITIONS_GT table
1477: --
1478:
1479: PROCEDURE Insert_Discount(
1480: P_acctg_date IN DATE,
1554: FETCH C_Discount
1555: INTO l_invoice_pay_id;
1556: EXIT WHEN C_Discount%NOTFOUND; */
1557: --
1558: l_debug_info := 'Insert into FA_MASS_ADDITIONS_GT';
1559: --
1560: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1561: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,l_debug_info);
1562: END IF;
1566: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Invoice Payment_Id: '
1567: ||TO_CHAR(l_invoice_pay_id));
1568: END IF;*/
1569: --
1570: INSERT INTO FA_MASS_ADDITIONS_GT(
1571: mass_addition_id,
1572: asset_number,
1573: tag_number,
1574: description,
2304:
2305: /*10368924: Extra debug message to debug duplicate rows in FA GT table*/
2306: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
2307: For I in (Select count(*) "CNT", invoice_distribution_id
2308: from fa_mass_additions_gt
2309: where line_status = 'PROCESSED'
2310: and line_type_lookup_code <> 'DISCOUNT'
2311: and ledger_id = l_ledger_id
2312: group by invoice_distribution_id
2341: END IF;
2342: /*10368924 end*/
2343:
2344: MERGE INTO ap_invoice_distributions_all apid
2345: USING fa_mass_additions_gt fmag
2346: ON (apid.invoice_distribution_id = fmag.invoice_distribution_id
2347: AND fmag.line_status = 'PROCESSED'
2348: AND fmag.ledger_id = l_ledger_id
2349: AND fmag.line_type_lookup_code <> 'DISCOUNT'
2360: l_count := SQL%ROWCOUNT;
2361: --
2362:
2363: MERGE INTO ap_self_assessed_tax_dist_all apid
2364: USING fa_mass_additions_gt fmag
2365: ON (apid.invoice_distribution_id = fmag.invoice_distribution_id
2366: AND fmag.line_status = 'PROCESSED'
2367: AND fmag.ledger_id = l_ledger_id
2368: AND fmag.line_type_lookup_code <> 'DISCOUNT'
2389: APID.request_id = FND_GLOBAL.conc_request_id,
2390: APID.asset_book_type_code = P_bt_code
2391: WHERE APID.invoice_distribution_id IN
2392: (SELECT FMAG.invoice_distribution_id
2393: FROM fa_mass_additions_gt FMAG
2394: WHERE FMAG.line_status = 'REJECTED'
2395: AND FMAG.ledger_id = l_ledger_id
2396: AND fmag.line_type_lookup_code <> 'DISCOUNT')
2397: AND APID.assets_addition_flag = 'U';
2406: APID.request_id = FND_GLOBAL.conc_request_id,
2407: APID.asset_book_type_code = P_bt_code
2408: WHERE APID.invoice_distribution_id IN
2409: (SELECT FMAG.invoice_distribution_id
2410: FROM fa_mass_additions_gt FMAG
2411: WHERE FMAG.line_status = 'REJECTED'
2412: AND FMAG.ledger_id = l_ledger_id
2413: AND fmag.line_type_lookup_code <> 'DISCOUNT')
2414: AND APID.assets_addition_flag = 'U';
2429: AND APIP.invoice_payment_id IN (
2430: SELECT APHD.invoice_payment_id
2431: FROM ap_payment_hist_dists APHD,
2432: ap_invoice_distributions_all APID,
2433: fa_mass_additions_gt FMAG
2434: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2435: AND APHD.invoice_distribution_id =
2436: APID.invoice_distribution_id
2437: AND APID.invoice_distribution_id =
2457: AND APIP.invoice_payment_id IN (
2458: SELECT APHD.invoice_payment_id
2459: FROM ap_payment_hist_dists APHD,
2460: ap_invoice_distributions_all APID,
2461: fa_mass_additions_gt FMAG
2462: WHERE APIP.invoice_payment_id = APHD.invoice_payment_id
2463: AND APHD.invoice_distribution_id =
2464: APID.invoice_distribution_id
2465: AND APID.invoice_distribution_id =