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_REVENUECOGSMATCH_PVT dependencies on CST_REVENUE_RECOGNITION_LINES

Line 423: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_REVENUE_RECOGNITION_LINES');

419: --{BUG#10627578
420: IF p_gather_statistics = 'Y' THEN
421: IF l_schema IS NOT NULL THEN
422: l_stmt_num := 37;
423: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_REVENUE_RECOGNITION_LINES');
424: END IF;
425: END IF;
426: --}
427: SAVEPOINT Match_RevenueCOGS_PVT; -- necessary because of commit within gather_table_stats

Line 444: UPDATE cst_revenue_recognition_lines crrl

440: -- concurrent request will not get picked up in this run.
441: l_stmt_num := 40;
442:
443:
444: UPDATE cst_revenue_recognition_lines crrl
445: SET potentially_unmatched_flag = 'Y'
446: WHERE potentially_unmatched_flag = 'U'
447: AND ledger_id = p_ledger_id;
448:

Line 1591: cst_revenue_recognition_lines crrl,

1587: ,MAX(mmt.acct_period_id) mmt_period_id
1588: --}
1589: ,MAX(crrl.rowid) l_rowid
1590: FROM cst_revenue_cogs_match_lines crcml,
1591: cst_revenue_recognition_lines crrl,
1592: cst_cogs_events cce,
1593: mtl_parameters mp,
1594: gl_period_statuses gps,
1595: cst_lists_temp clt,

Line 1647: FROM cst_revenue_recognition_lines crrl

1643:
1644:
1645: CURSOR cu_period(p_ledger_id IN NUMBER) IS
1646: SELECT DISTINCT crrl.acct_period_num
1647: FROM cst_revenue_recognition_lines crrl
1648: WHERE crrl.ledger_id = p_ledger_id
1649: AND crrl.potentially_unmatched_flag = 'Y'
1650: ORDER BY crrl.acct_period_num ASC;
1651:

Line 1771: FROM cst_revenue_recognition_lines crrl,

1767: 'TIMEZONE'
1768: FROM ( SELECT
1769: DISTINCT caiv.organization_id,
1770: caiv.legal_entity
1771: FROM cst_revenue_recognition_lines crrl,
1772: cst_revenue_cogs_match_lines crcml,
1773: cst_acct_info_v caiv
1774: WHERE crrl.potentially_unmatched_flag='Y'
1775: AND crcml.revenue_om_line_id =crrl.revenue_om_line_id

Line 1833: ,cst_revenue_recognition_lines crrl

1829: ,MIN(glp.effective_period_num)
1830: INTO l_max_period_num --l_rev_cogs_period_num
1831: ,l_min_period_num
1832: FROM gl_period_statuses glp
1833: ,cst_revenue_recognition_lines crrl
1834: ,cst_revenue_cogs_match_lines crcml
1835: ,cst_cogs_events cce
1836: WHERE crrl.acct_period_num = l_per_num_tab(j)
1837: AND crrl.potentially_unmatched_flag = 'Y'

Line 2433: UPDATE cst_revenue_recognition_lines

2429: debug(l_stmt_num);
2430:
2431:
2432: FORALL i IN l_upd_rowid_tab.FIRST .. l_upd_rowid_tab.LAST
2433: UPDATE cst_revenue_recognition_lines
2434: SET potentially_unmatched_flag = NULL,
2435: last_update_date = SYSDATE,
2436: last_updated_by = p_user_id,
2437: last_update_login = p_login_id,

Line 2454: UPDATE cst_revenue_recognition_lines

2450: CLOSE c_mismatched_lines;
2451: -- Abnormal situation
2452: -- The line at Y should be in NULL
2453: -- "I" means investigation
2454: UPDATE cst_revenue_recognition_lines
2455: SET potentially_unmatched_flag = 'I',
2456: last_update_date = SYSDATE,
2457: last_updated_by = p_user_id,
2458: last_update_login = p_login_id,

Line 2757: UPDATE cst_revenue_recognition_lines

2753:
2754: l_stmt_num := 50;
2755: debug(l_stmt_num);
2756: -- Now update CRRL to mark any lines that may be unmatched due to this SO insert
2757: UPDATE cst_revenue_recognition_lines
2758: SET potentially_unmatched_flag = 'Y',
2759: last_update_date = sysdate,
2760: last_updated_by = p_user_id,
2761: last_update_login = p_login_id,

Line 7014: FROM cst_revenue_recognition_lines crrl

7010:
7011: CURSOR c_no_ledger IS
7012: SELECT COUNT(*)
7013: , ledger_id
7014: FROM cst_revenue_recognition_lines crrl
7015: WHERE potentially_unmatched_flag = 'Y'
7016: GROUP BY ledger_id
7017: HAVING COUNT(*) > 0;
7018:

Line 7058: -- PROCEDURE grouping cst_revenue_recognition_lines to be processed

7054: END crrl_preparation;
7055:
7056:
7057: ------------------
7058: -- PROCEDURE grouping cst_revenue_recognition_lines to be processed
7059: -- by a request
7060: -- Using the request_id column of the table CRRL
7061: -- This needs to be evaluated but for now we avoid schema changes
7062: -- At the end of the process the request_id in CRRL should back to the

Line 7072: FROM cst_revenue_recognition_lines crrl

7068: IS
7069: CURSOR c IS
7070: SELECT ROWID,
7071: revenue_om_line_id
7072: FROM cst_revenue_recognition_lines crrl
7073: WHERE potentially_unmatched_flag = 'Y'
7074: AND ledger_id = p_ledger_id
7075: ORDER BY revenue_om_line_id ASC;
7076:

Line 7096: UPDATE cst_revenue_recognition_lines

7092: INTO l_gp_id
7093: FROM dual;
7094:
7095: FORALL j IN p_rowid_tab.FIRST .. p_rowid_tab.LAST
7096: UPDATE cst_revenue_recognition_lines
7097: SET request_id = -1 * l_gp_id
7098: WHERE rowid = p_rowid_tab(j);
7099: COMMIT;
7100: debug(' CST_REV_REC_LINES updated with request_ID ='|| -1 * l_gp_id ||' for the ledger '||p_ledger_id ||

Line 7488: FROM cst_revenue_recognition_lines CRRL

7484: IS
7485: CURSOR c_revenue_only_lines(p_ledger_id IN NUMBER) IS
7486: SELECT crrl.rowid l_rowid
7487: , 'P' flag
7488: FROM cst_revenue_recognition_lines CRRL
7489: WHERE CRRL.potentially_unmatched_flag = 'Y'
7490: AND CRRL.ledger_id = p_ledger_id
7491: AND (NOT EXISTS (SELECT NULL
7492: FROM cst_revenue_cogs_match_lines CRCML

Line 7525: FROM cst_revenue_recognition_lines CRRL

7521: AND mmt.transaction_type_id = 30))
7522: UNION ALL
7523: SELECT crrl.rowid l_rowid
7524: , 'Y' flag
7525: FROM cst_revenue_recognition_lines CRRL
7526: WHERE CRRL.potentially_unmatched_flag = 'P'
7527: AND CRRL.ledger_id = p_ledger_id
7528: AND EXISTS (SELECT NULL
7529: FROM cst_revenue_cogs_match_lines CRCML

Line 7570: FROM cst_revenue_recognition_lines CRRL

7566: -- as revenue is cumulative
7567: --
7568: SELECT crrl.rowid l_rowid
7569: , DECODE(crrl.acct_period_num,latest_rev.mper,'Y',NULL) flag
7570: FROM cst_revenue_recognition_lines CRRL
7571: , cst_revenue_cogs_match_lines crcml
7572: , cst_cogs_events cce
7573: , gl_period_statuses glp
7574: , (SELECT MAX(crrl3.acct_period_num) mper

Line 7576: FROM cst_revenue_recognition_lines crrl3

7572: , cst_cogs_events cce
7573: , gl_period_statuses glp
7574: , (SELECT MAX(crrl3.acct_period_num) mper
7575: , crrl3.revenue_om_line_id
7576: FROM cst_revenue_recognition_lines crrl3
7577: WHERE crrl3.potentially_unmatched_flag = 'Y'
7578: group by crrl3.revenue_om_line_id) latest_rev
7579: WHERE CRRL.potentially_unmatched_flag = 'Y'
7580: AND CRRL.ledger_id = p_ledger_id

Line 7612: UPDATE cst_revenue_recognition_lines CRRL

7608: IF c_revenue_only_lines%NOTFOUND AND l_rowid_tab.Count=0 THEN
7609: EXIT;
7610: END IF;
7611: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
7612: UPDATE cst_revenue_recognition_lines CRRL
7613: SET potentially_unmatched_flag = l_flag_tab(i)
7614: where CRRL.ROWID = l_rowid_tab(i);
7615: COMMIT;
7616: END LOOP;

Line 7631: UPDATE cst_revenue_recognition_lines CRRL

7627: IF c_prepare%NOTFOUND AND l_rowid_tab.Count=0 THEN
7628: EXIT;
7629: END IF;
7630: FORALL i IN l_rowid_tab.FIRST .. l_rowid_tab.LAST
7631: UPDATE cst_revenue_recognition_lines CRRL
7632: SET potentially_unmatched_flag = l_flag_tab(i)
7633: where CRRL.ROWID = l_rowid_tab(i);
7634: COMMIT;
7635: END LOOP;