eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_ACCRUAL_LOAD dependencies on CST_MISC_RECONCILIATION

Line 2358: DELETE from cst_misc_reconciliation

2354: debug(' l_stmt_num :'||l_stmt_num );
2355:
2356:
2357: /* Delete data from misc reconciliation table for the time range */
2358: DELETE from cst_misc_reconciliation
2359: WHERE transaction_date between p_from_date AND p_to_date
2360: AND operating_unit_id = p_operating_unit;
2361:
2362: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);

Line 2362: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);

2358: DELETE from cst_misc_reconciliation
2359: WHERE transaction_date between p_from_date AND p_to_date
2360: AND operating_unit_id = p_operating_unit;
2361:
2362: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2363:
2364: l_stmt_num := 25;
2365: debug(' l_stmt_num :'||l_stmt_num );
2366:

Line 2378: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);

2374: they are actually rounded amounts since AP always passes rounded amounts to SLA and no further rounding in SLA is
2375: possible. */
2376:
2377:
2378: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2379:
2380: debug(' Inserting into cst_misc_reconciliation');
2381: Insert into cst_misc_reconciliation
2382: (

Line 2380: debug(' Inserting into cst_misc_reconciliation');

2376:
2377:
2378: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2379:
2380: debug(' Inserting into cst_misc_reconciliation');
2381: Insert into cst_misc_reconciliation
2382: (
2383: transaction_date,
2384: amount,

Line 2381: Insert into cst_misc_reconciliation

2377:
2378: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2379:
2380: debug(' Inserting into cst_misc_reconciliation');
2381: Insert into cst_misc_reconciliation
2382: (
2383: transaction_date,
2384: amount,
2385: entered_amount,

Line 2670: | data into cst_misc_reconciliation table,bug 6995413 |

2666: | x_msg_data OUT NOCOPY VARCHAR2 |
2667: | |
2668: | NOTES : None |
2669: | 11-Aug-2008 pmarada Added code to insert OPM financials related inventory |
2670: | data into cst_misc_reconciliation table,bug 6995413 |
2671: | 17-Apr-2012 Uday Phadtare Bug 13728770.
2672: | In case of for OPM Financials module, used separate queries for entity_code PURCHASING and INVENTORY.
2673: +===========================================================================*/
2674:

Line 2808: debug(' Inserting into cst_misc_reconciliation' );

2804: debug(' l_misc_inv:'||l_misc_inv);
2805:
2806: IF l_misc_inv = 'Y' THEN
2807:
2808: debug(' Inserting into cst_misc_reconciliation' );
2809:
2810: Insert into cst_misc_reconciliation
2811: (
2812: transaction_date,

Line 2810: Insert into cst_misc_reconciliation

2806: IF l_misc_inv = 'Y' THEN
2807:
2808: debug(' Inserting into cst_misc_reconciliation' );
2809:
2810: Insert into cst_misc_reconciliation
2811: (
2812: transaction_date,
2813: amount,
2814: entered_amount,

Line 2946: Insert into cst_misc_reconciliation

2942: l_stmt_num := 25;
2943: debug(' l_stmt_num :'|| l_stmt_num);
2944: debug(' OPM misc inventory insertion');
2945:
2946: Insert into cst_misc_reconciliation
2947: (
2948: transaction_date,
2949: amount,
2950: entered_amount,

Line 3160: UPDATE cst_misc_reconciliation cmr

3156:
3157: /* Update Intercompany INV txns with the Vendor information */
3158: debug(' Inserting miscellenaous inventory for discrete');
3159:
3160: UPDATE cst_misc_reconciliation cmr
3161: SET cmr.vendor_id = (
3162: SELECT mip.vendor_id
3163: FROM mtl_material_transactions mmt,
3164: mtl_intercompany_parameters mip,

Line 3197: Update CST_MISC_RECONCILIATION cmr

3193: /* Update PO_DISTRIBUTION_ID for consigned ownership transfer txns so that balancing txns can then be deleted */
3194:
3195: debug(' Updating the PO_DISTRIBUTION_ID for consigned INV transactions');
3196:
3197: Update CST_MISC_RECONCILIATION cmr
3198: Set po_distribution_id = (select mct.po_distribution_id
3199: from mtl_consumption_transactions mct
3200: where mct.consumption_processed_flag = 'Y'
3201: AND mct.transaction_id in

Line 3219: DELETE FROM cst_misc_reconciliation cmr

3215: debug(' Deleting the Consigment transactions that balance out');
3216:
3217: /* Now delete all the Consigned matching txns after grouping them by po_distribution_id */
3218:
3219: DELETE FROM cst_misc_reconciliation cmr
3220: WHERE cmr.transaction_type_code = 'CONSIGNMENT'
3221: AND cmr.operating_unit_id = p_operating_unit
3222: AND cmr.po_distribution_id is NOT NULL
3223: AND EXISTS ( SELECT 1

Line 3224: FROM cst_misc_reconciliation cmr2

3220: WHERE cmr.transaction_type_code = 'CONSIGNMENT'
3221: AND cmr.operating_unit_id = p_operating_unit
3222: AND cmr.po_distribution_id is NOT NULL
3223: AND EXISTS ( SELECT 1
3224: FROM cst_misc_reconciliation cmr2
3225: WHERE cmr2.po_distribution_id = cmr.po_distribution_id
3226: AND cmr2.accrual_account_id = cmr.accrual_account_id
3227: AND cmr2.operating_unit_id = p_operating_unit
3228: HAVING SUM(cmr2.amount) = 0