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 347: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_REVENUE_RECOGNITION_LINES');

343: END IF;
344:
345: IF l_schema IS NOT NULL THEN
346: l_stmt_num := 37;
347: FND_STATS.GATHER_TABLE_STATS(l_schema, 'CST_REVENUE_RECOGNITION_LINES');
348: END IF;
349: SAVEPOINT Match_RevenueCOGS_PVT; -- necessary because of commit within gather_table_stats
350:
351: END IF; -- phase 2

Line 364: UPDATE cst_revenue_recognition_lines crrl

360:
361: -- Update all rows from OM so that any OLTP rows coming in during the
362: -- concurrent request will not get picked up in this run.
363: l_stmt_num := 40;
364: UPDATE cst_revenue_recognition_lines crrl
365: SET potentially_unmatched_flag = 'Y'
366: WHERE potentially_unmatched_flag = 'U';
367:
368: l_stmt_num := 50;

Line 393: UPDATE cst_revenue_recognition_lines crrl

389: l_stmt_num := 60;
390:
391: IF p_neg_req_id IS NULL THEN
392:
393: UPDATE cst_revenue_recognition_lines crrl
394: SET potentially_unmatched_flag = NULL,
395: last_update_date = sysdate,
396: last_updated_by = l_user_id,
397: last_update_login = l_login_id,

Line 407: UPDATE cst_revenue_recognition_lines crrl

403: AND ledger_id = NVL(p_ledger_id,ledger_id); --BUG5726230
404:
405: ELSE
406:
407: UPDATE cst_revenue_recognition_lines crrl
408: SET potentially_unmatched_flag = NULL,
409: last_update_date = sysdate,
410: last_updated_by = l_user_id,
411: last_update_login = l_login_id,

Line 1408: cst_revenue_recognition_lines crrl,

1404: ,MAX(mmt.transaction_date) + clt.number_1 mmt_transaction_date
1405: ,MAX(mmt.acct_period_id) mmt_period_id
1406: --}
1407: FROM cst_revenue_cogs_match_lines crcml,
1408: cst_revenue_recognition_lines crrl,
1409: cst_cogs_events cce,
1410: mtl_parameters mp,
1411: gl_period_statuses gps,
1412: cst_lists_temp clt,

Line 1566: FROM cst_revenue_recognition_lines crrl,

1562: ) - l_dummy_date
1563: FROM ( SELECT
1564: DISTINCT caiv.organization_id,
1565: caiv.legal_entity
1566: FROM cst_revenue_recognition_lines crrl,
1567: cst_revenue_cogs_match_lines crcml,
1568: cst_acct_info_v caiv
1569: WHERE crrl.potentially_unmatched_flag='Y'
1570: AND DECODE(p_neg_req_id,NULL,NVL(crrl.request_id,-99),p_neg_req_id) = NVL(crrl.request_id,-99)

Line 1593: FROM cst_revenue_recognition_lines crrl,

1589: ) - l_dummy_date
1590: FROM ( SELECT
1591: DISTINCT caiv.organization_id,
1592: caiv.legal_entity
1593: FROM cst_revenue_recognition_lines crrl,
1594: cst_revenue_cogs_match_lines crcml,
1595: cst_acct_info_v caiv
1596: WHERE crrl.potentially_unmatched_flag='Y'
1597: AND crcml.revenue_om_line_id =crrl.revenue_om_line_id

Line 1628: -- INTO cst_revenue_recognition_lines target_crrl

1624: -- Confirm with AR in the bug#7438582
1625: --------------------------
1626: -- l_stmt_num := 4;
1627: -- MERGE
1628: -- INTO cst_revenue_recognition_lines target_crrl
1629: -- USING (
1630: -- SELECT crcml.revenue_om_line_id,
1631: -- gps.effective_period_num,
1632: -- crrl.revenue_recognition_percent,

Line 1641: -- cst_revenue_recognition_lines crrl

1637: -- FROM cst_revenue_cogs_match_lines crcml,
1638: -- cst_lists_temp clt,
1639: -- gl_period_statuses gps,
1640: -- cst_cogs_events cce,
1641: -- cst_revenue_recognition_lines crrl
1642: -- WHERE crcml.pac_cost_type_id IS NULL
1643: -- AND clt.list_id = crcml.organization_id
1644: -- AND gps.application_id = 222
1645: -- AND gps.set_of_books_id = crrl.ledger_id

Line 1656: -- FROM cst_revenue_recognition_lines

1652: -- pick the last rev rec percent prior to this period
1653: -- AND crrl.revenue_om_line_id = crcml.revenue_om_line_id
1654: -- AND crrl.last_event_date = (
1655: -- SELECT /*+ no_unnest */ MAX(last_event_date) -- Add hint for bug#6697330
1656: -- FROM cst_revenue_recognition_lines
1657: -- WHERE revenue_om_line_id = crcml.revenue_om_line_id
1658: -- AND last_event_date < gps.start_date
1659: -- )
1660: -- GROUP

Line 1754: FROM cst_revenue_recognition_lines crrl,

1750: IF p_neg_req_id IS NULL THEN
1751:
1752: SELECT min(crrl.acct_period_num)
1753: INTO l_revenue_acct_period_num
1754: FROM cst_revenue_recognition_lines crrl,
1755: cst_revenue_cogs_match_lines crcml,
1756: cst_cogs_events cce,
1757: cst_lists_temp clt,
1758: gl_period_statuses gps

Line 1786: FROM cst_revenue_recognition_lines

1782: and cogs_om_line_id = crcml.cogs_om_line_id
1783: and prior_event_id = cce.parent_event_id)
1784: AND cce.cogs_percentage <> (
1785: SELECT SUM(revenue_recognition_percent)
1786: FROM cst_revenue_recognition_lines
1787: WHERE revenue_om_line_id = crrl.revenue_om_line_id
1788: AND last_event_date <= crrl.last_event_date
1789: )
1790: AND crcml.pac_cost_type_id IS NULL;

Line 1796: FROM cst_revenue_recognition_lines crrl,

1792: ELSE
1793:
1794: SELECT min(crrl.acct_period_num)
1795: INTO l_revenue_acct_period_num
1796: FROM cst_revenue_recognition_lines crrl,
1797: cst_revenue_cogs_match_lines crcml,
1798: cst_cogs_events cce,
1799: cst_lists_temp clt,
1800: gl_period_statuses gps

Line 1818: FROM cst_revenue_recognition_lines

1814: and cogs_om_line_id = crcml.cogs_om_line_id
1815: and prior_event_id = cce.parent_event_id)
1816: AND cce.cogs_percentage <> (
1817: SELECT SUM(revenue_recognition_percent)
1818: FROM cst_revenue_recognition_lines
1819: WHERE revenue_om_line_id = crrl.revenue_om_line_id
1820: AND last_event_date <= crrl.last_event_date
1821: )
1822: AND crcml.pac_cost_type_id IS NULL;

Line 2399: UPDATE cst_revenue_recognition_lines crrl

2395: l_stmt_num := 190;
2396: debug(l_stmt_num);
2397:
2398: IF p_neg_req_id IS NULL THEN
2399: UPDATE cst_revenue_recognition_lines crrl
2400: SET potentially_unmatched_flag = NULL,
2401: last_update_date = sysdate,
2402: last_updated_by = p_user_id,
2403: last_update_login = p_login_id,

Line 2414: UPDATE cst_revenue_recognition_lines crrl

2410: AND acct_period_num = l_revenue_acct_period_num;
2411:
2412: ELSE
2413:
2414: UPDATE cst_revenue_recognition_lines crrl
2415: SET potentially_unmatched_flag = NULL,
2416: last_update_date = sysdate,
2417: last_updated_by = p_user_id,
2418: last_update_login = p_login_id,

Line 2719: UPDATE cst_revenue_recognition_lines

2715:
2716: l_stmt_num := 50;
2717: debug(l_stmt_num);
2718: -- Now update CRRL to mark any lines that may be unmatched due to this SO insert
2719: UPDATE cst_revenue_recognition_lines
2720: SET potentially_unmatched_flag = 'Y',
2721: last_update_date = sysdate,
2722: last_updated_by = p_user_id,
2723: last_update_login = p_login_id,

Line 6670: FROM cst_revenue_recognition_lines crrl

6666:
6667: CURSOR c_no_ledger IS
6668: SELECT COUNT(*)
6669: , ledger_id
6670: FROM cst_revenue_recognition_lines crrl
6671: WHERE potentially_unmatched_flag = 'Y'
6672: GROUP BY ledger_id
6673: HAVING COUNT(*) > 0;
6674:

Line 6714: -- PROCEDURE grouping cst_revenue_recognition_lines to be processed

6710: END crrl_preparation;
6711:
6712:
6713: ------------------
6714: -- PROCEDURE grouping cst_revenue_recognition_lines to be processed
6715: -- by a request
6716: -- Using the request_id column of the table CRRL
6717: -- This needs to be evaluated but for now we avoid schema changes
6718: -- At the end of the process the request_id in CRRL should back to the

Line 6728: FROM cst_revenue_recognition_lines crrl

6724: IS
6725: CURSOR c IS
6726: SELECT ROWID,
6727: revenue_om_line_id
6728: FROM cst_revenue_recognition_lines crrl
6729: WHERE potentially_unmatched_flag = 'Y'
6730: AND ledger_id = p_ledger_id
6731: ORDER BY revenue_om_line_id ASC;
6732:

Line 6752: UPDATE cst_revenue_recognition_lines

6748: INTO l_gp_id
6749: FROM dual;
6750:
6751: FORALL j IN p_rowid_tab.FIRST .. p_rowid_tab.LAST
6752: UPDATE cst_revenue_recognition_lines
6753: SET request_id = -1 * l_gp_id
6754: WHERE rowid = p_rowid_tab(j);
6755: COMMIT;
6756: debug(' CST_REV_REC_LINES updated with request_ID ='|| -1 * l_gp_id ||' for the ledger '||p_ledger_id ||