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 2288: DELETE from cst_misc_reconciliation

2284: debug(' l_stmt_num :'||l_stmt_num );
2285:
2286:
2287: /* Delete data from misc reconciliation table for the time range */
2288: DELETE from cst_misc_reconciliation
2289: WHERE transaction_date between p_from_date AND p_to_date
2290: AND operating_unit_id = p_operating_unit;
2291:
2292: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);

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

2288: DELETE from cst_misc_reconciliation
2289: WHERE transaction_date between p_from_date AND p_to_date
2290: AND operating_unit_id = p_operating_unit;
2291:
2292: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2293:
2294: l_stmt_num := 25;
2295: debug(' l_stmt_num :'||l_stmt_num );
2296:

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

2304: they are actually rounded amounts since AP always passes rounded amounts to SLA and no further rounding in SLA is
2305: possible. */
2306:
2307:
2308: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2309:
2310: debug(' Inserting into cst_misc_reconciliation');
2311: Insert into cst_misc_reconciliation
2312: (

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

2306:
2307:
2308: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2309:
2310: debug(' Inserting into cst_misc_reconciliation');
2311: Insert into cst_misc_reconciliation
2312: (
2313: transaction_date,
2314: amount,

Line 2311: Insert into cst_misc_reconciliation

2307:
2308: debug(' Nb rows deleted from cst_misc_reconciliation '||SQL%ROWCOUNT);
2309:
2310: debug(' Inserting into cst_misc_reconciliation');
2311: Insert into cst_misc_reconciliation
2312: (
2313: transaction_date,
2314: amount,
2315: entered_amount,

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

2509: | x_msg_data OUT NOCOPY VARCHAR2 |
2510: | |
2511: | NOTES : None |
2512: | 11-Aug-2008 pmarada Added code to insert OPM financials related inventory |
2513: | data into cst_misc_reconciliation table,bug 6995413 |
2514: +===========================================================================*/
2515:
2516: Procedure Load_inv_misc_data(p_operating_unit IN NUMBER,
2517: p_from_date IN DATE,

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

2597:
2598: /* Insert INV data into the MISC details table. If there is a write off against the Txn, the txn will be
2599: inserted only if the write off has been reverse written off or the txn has never been written off. */
2600:
2601: debug(' Inserting into cst_misc_reconciliation' );
2602:
2603: Insert into cst_misc_reconciliation
2604: (
2605: transaction_date,

Line 2603: Insert into cst_misc_reconciliation

2599: inserted only if the write off has been reverse written off or the txn has never been written off. */
2600:
2601: debug(' Inserting into cst_misc_reconciliation' );
2602:
2603: Insert into cst_misc_reconciliation
2604: (
2605: transaction_date,
2606: amount,
2607: entered_amount,

Line 2733: Insert into cst_misc_reconciliation

2729: l_stmt_num := 25;
2730: debug(' l_stmt_num :'|| l_stmt_num);
2731: debug(' OPM misc inventory insertion');
2732:
2733: Insert into cst_misc_reconciliation
2734: (
2735: transaction_date,
2736: amount,
2737: entered_amount,

Line 2862: UPDATE cst_misc_reconciliation cmr

2858:
2859: /* Update Intercompany INV txns with the Vendor information */
2860: debug(' Inserting miscellenaous inventory for discrete');
2861:
2862: UPDATE cst_misc_reconciliation cmr
2863: SET cmr.vendor_id = (
2864: SELECT mip.vendor_id
2865: FROM mtl_material_transactions mmt,
2866: mtl_intercompany_parameters mip,

Line 2899: Update CST_MISC_RECONCILIATION cmr

2895: /* Update PO_DISTRIBUTION_ID for consigned ownership transfer txns so that balancing txns can then be deleted */
2896:
2897: debug(' Updating the PO_DISTRIBUTION_ID for consigned INV transactions');
2898:
2899: Update CST_MISC_RECONCILIATION cmr
2900: Set po_distribution_id = (select mct.po_distribution_id
2901: from mtl_consumption_transactions mct
2902: where mct.consumption_processed_flag = 'Y'
2903: AND mct.transaction_id in

Line 2921: DELETE FROM cst_misc_reconciliation cmr

2917: debug(' Deleting the Consigment transactions that balance out');
2918:
2919: /* Now delete all the Consigned matching txns after grouping them by po_distribution_id */
2920:
2921: DELETE FROM cst_misc_reconciliation cmr
2922: WHERE cmr.transaction_type_code = 'CONSIGNMENT'
2923: AND cmr.operating_unit_id = p_operating_unit
2924: AND cmr.po_distribution_id is NOT NULL
2925: AND EXISTS ( SELECT 1

Line 2926: FROM cst_misc_reconciliation cmr2

2922: WHERE cmr.transaction_type_code = 'CONSIGNMENT'
2923: AND cmr.operating_unit_id = p_operating_unit
2924: AND cmr.po_distribution_id is NOT NULL
2925: AND EXISTS ( SELECT 1
2926: FROM cst_misc_reconciliation cmr2
2927: WHERE cmr2.po_distribution_id = cmr.po_distribution_id
2928: AND cmr2.accrual_account_id = cmr.accrual_account_id
2929: AND cmr2.operating_unit_id = p_operating_unit
2930: HAVING SUM(cmr2.amount) = 0