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_LISTS_TEMP

Line 1412: cst_lists_temp clt,

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,
1413: mtl_system_items msi
1414: --{BUG#6809034
1415: ,mtl_material_transactions mmt
1416: --}

Line 1545: DELETE cst_lists_temp;

1541: l_dummy_date := sysdate;
1542:
1543: l_stmt_num := 1;
1544:
1545: DELETE cst_lists_temp;
1546:
1547:
1548: --{BUG#5726230
1549: IF p_ledger_id IS NULL THEN

Line 1554: INTO cst_lists_temp (

1550:
1551: --BUG#5726230 Current behaviour across multiple Ledgers
1552: --
1553: INSERT
1554: INTO cst_lists_temp (
1555: list_id,
1556: number_1
1557: )
1558: SELECT organization_id,

Line 1581: INTO cst_lists_temp (

1577:
1578: --BUG#5726230 Restrict to a single ledger
1579: --
1580: INSERT
1581: INTO cst_lists_temp (
1582: list_id,
1583: number_1
1584: )
1585: SELECT organization_id,

Line 1638: -- cst_lists_temp clt,

1634: -- crrl.operating_unit_id,
1635: -- crrl.ledger_id,
1636: -- crrl.inventory_item_id
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

Line 1757: cst_lists_temp clt,

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
1759: --{
1760: -- , cst_cogs_events cce2
1761: --}

Line 1799: cst_lists_temp clt,

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
1801: WHERE crrl.ledger_id = l_sob --l_sob.set_of_books_id
1802: AND crrl.potentially_unmatched_flag = 'Y'
1803: AND crrl.request_id = p_neg_req_id --BUG#7387575

Line 4322: -- cst_lists_temp with opposite signs

4318: END LOOP;
4319:
4320: l_stmt_num := 20;
4321: -- To help create debits and credits in bulk, insert 2 simple rows in
4322: -- cst_lists_temp with opposite signs
4323: -- These insertions are inside the loop because the commit at stmt 80
4324: -- blows these away.
4325: -- Keeping these inserts inside the loop (instead of doing once outside
4326: -- the loop) in case the definition of the cst_lists_temp table ever

Line 4326: -- the loop) in case the definition of the cst_lists_temp table ever

4322: -- cst_lists_temp with opposite signs
4323: -- These insertions are inside the loop because the commit at stmt 80
4324: -- blows these away.
4325: -- Keeping these inserts inside the loop (instead of doing once outside
4326: -- the loop) in case the definition of the cst_lists_temp table ever
4327: -- changes from session to txn based. If the definition changes, there
4328: -- is no need to change it here since I'm deleting and reinserting each
4329: -- commit cycle.
4330: DELETE cst_lists_temp;

Line 4330: DELETE cst_lists_temp;

4326: -- the loop) in case the definition of the cst_lists_temp table ever
4327: -- changes from session to txn based. If the definition changes, there
4328: -- is no need to change it here since I'm deleting and reinserting each
4329: -- commit cycle.
4330: DELETE cst_lists_temp;
4331:
4332: INSERT INTO cst_lists_temp (list_id)
4333: VALUES (1); -- Dr.
4334:

Line 4332: INSERT INTO cst_lists_temp (list_id)

4328: -- is no need to change it here since I'm deleting and reinserting each
4329: -- commit cycle.
4330: DELETE cst_lists_temp;
4331:
4332: INSERT INTO cst_lists_temp (list_id)
4333: VALUES (1); -- Dr.
4334:
4335: INSERT INTO cst_lists_temp (list_id)
4336: VALUES (-1); -- Cr.

Line 4335: INSERT INTO cst_lists_temp (list_id)

4331:
4332: INSERT INTO cst_lists_temp (list_id)
4333: VALUES (1); -- Dr.
4334:
4335: INSERT INTO cst_lists_temp (list_id)
4336: VALUES (-1); -- Cr.
4337:
4338: -- The following statement will create elemental distributions for all source rows returned
4339: -- by the above cursor.

Line 4410: cst_lists_temp clt,

4406: p_pgm_app_id,
4407: p_pgm_id,
4408: sysdate
4409: FROM cst_cost_elements cce,
4410: cst_lists_temp clt,
4411: fnd_currencies fc
4412: WHERE fc.currency_code = l_currency_code_tbl(i)
4413: AND l_event_quantity_tbl(i) <> 0
4414: AND l_cogs_percentage_tbl(i) <> l_prior_percentage_tbl(i)

Line 6759: INSERT INTO cst_lists_temp

6755: COMMIT;
6756: debug(' CST_REV_REC_LINES updated with request_ID ='|| -1 * l_gp_id ||' for the ledger '||p_ledger_id ||
6757: ' Number of records CRRL updated is '|| l_upd_rowid_tab.COUNT);
6758:
6759: INSERT INTO cst_lists_temp
6760: ( list_id
6761: ,number_1
6762: ,VARCHAR_1) VALUES (p_ledger_id
6763: , -1 * l_gp_id

Line 6765: debug(' CST_LISTS_TEMP.list_id = ledger_id : '||p_ledger_id);

6761: ,number_1
6762: ,VARCHAR_1) VALUES (p_ledger_id
6763: , -1 * l_gp_id
6764: , 'INSERTED');
6765: debug(' CST_LISTS_TEMP.list_id = ledger_id : '||p_ledger_id);
6766: debug(' CST_LISTS_TEMP.number_1 = CRRL.request_id for process: '||-1 * l_gp_id);
6767: debug(' CST_LISTS_TEMP.varchar_1= STATUS of Request : INSERTED');
6768: END update_one_set_crrl;
6769:

Line 6766: debug(' CST_LISTS_TEMP.number_1 = CRRL.request_id for process: '||-1 * l_gp_id);

6762: ,VARCHAR_1) VALUES (p_ledger_id
6763: , -1 * l_gp_id
6764: , 'INSERTED');
6765: debug(' CST_LISTS_TEMP.list_id = ledger_id : '||p_ledger_id);
6766: debug(' CST_LISTS_TEMP.number_1 = CRRL.request_id for process: '||-1 * l_gp_id);
6767: debug(' CST_LISTS_TEMP.varchar_1= STATUS of Request : INSERTED');
6768: END update_one_set_crrl;
6769:
6770: PROCEDURE add_rowid

Line 6767: debug(' CST_LISTS_TEMP.varchar_1= STATUS of Request : INSERTED');

6763: , -1 * l_gp_id
6764: , 'INSERTED');
6765: debug(' CST_LISTS_TEMP.list_id = ledger_id : '||p_ledger_id);
6766: debug(' CST_LISTS_TEMP.number_1 = CRRL.request_id for process: '||-1 * l_gp_id);
6767: debug(' CST_LISTS_TEMP.varchar_1= STATUS of Request : INSERTED');
6768: END update_one_set_crrl;
6769:
6770: PROCEDURE add_rowid
6771: ( p_rowid IN VARCHAR2

Line 6849: FROM cst_lists_temp

6845: CURSOR c_ins IS
6846: SELECT list_id -- ledger_id
6847: ,number_1 -- process_negative_request_id
6848: ,rowid
6849: FROM cst_lists_temp
6850: WHERE VARCHAR_1 = 'INSERTED';
6851:
6852: CURSOR c_cpt IS
6853: SELECT COUNT(*)

Line 6854: FROM cst_lists_temp

6850: WHERE VARCHAR_1 = 'INSERTED';
6851:
6852: CURSOR c_cpt IS
6853: SELECT COUNT(*)
6854: FROM cst_lists_temp
6855: WHERE VARCHAR_1 = 'SUBMITTED';
6856:
6857: l_ledger_id NUMBER;
6858: l_neg_req_id NUMBER;

Line 6902: UPDATE cst_lists_temp

6898: ,argument6 => l_neg_req_id);
6899: IF l_req_id > 0 THEN
6900: debug(' Submitted Concurrent request for CSTRCMCR3S with ledger_id '||l_ledger_id||
6901: ' and process_request_id '||l_neg_req_id);
6902: UPDATE cst_lists_temp
6903: SET number_2 = l_req_id
6904: ,VARCHAR_1 = 'SUBMITTED'
6905: WHERE ROWID = l_rowid;
6906: COMMIT;

Line 6916: FROM cst_lists_temp

6912: debug(' Verifying number of active requests');
6913: nb_req_active;
6914: SELECT COUNT(*)
6915: INTO l_nb_req_sub
6916: FROM cst_lists_temp
6917: WHERE VARCHAR_1 = 'SUBMITTED';
6918:
6919: debug(' Number of request active after verification :'||l_nb_req_sub);
6920: IF l_nb_req_sub < p_nb_worker THEN

Line 6944: FROM cst_lists_temp

6940: IS
6941: CURSOR c_activity IS
6942: SELECT number_2
6943: ,rowid
6944: FROM cst_lists_temp
6945: WHERE varchar_1 = 'SUBMITTED';
6946:
6947: l_req_id_tab DBMS_SQL.NUMBER_TABLE;
6948: l_rowid_tab DBMS_SQL.VARCHAR2_TABLE;

Line 6993: UPDATE cst_lists_temp

6989: debug(l_message);
6990: END IF;
6991: --
6992: debug(' Updating the request as COMPLETED');
6993: UPDATE cst_lists_temp
6994: SET varchar_1 = l_dev_phase
6995: WHERE rowid = l_rowid_tab(i);
6996: END IF;
6997: END LOOP;