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_COSTPROCVALIDATION_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 30: FROM mtl_material_transactions

26:
27: CURSOR orgs_to_process
28: IS
29: SELECT DISTINCT organization_id
30: FROM mtl_material_transactions
31: WHERE costed_flag = 'N';
32:
33: /* Period Close Diagnostics: Added new cursor */
34: CURSOR orgs_with_error

Line 38: FROM mtl_material_transactions mmt,

34: CURSOR orgs_with_error
35: IS
36: SELECT mp.organization_code,
37: count (transaction_id)
38: FROM mtl_material_transactions mmt,
39: mtl_parameters mp
40: WHERE mmt.costed_flag = 'E'
41: AND mmt.last_update_date >= l_start_date
42: AND mp.organization_id = mmt.organization_id

Line 121: UPDATE /+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) /

117: WHERE application_id = l_application_id
118: AND concurrent_program_name = l_concurrent_program_name;
119:
120: l_stmt_num := 40;
121: UPDATE /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
122: mtl_material_transactions MMT
123: SET transaction_group_id = NULL,
124: last_update_date = SYSDATE,
125: last_updated_by = l_last_updated_by,

Line 122: mtl_material_transactions MMT

118: AND concurrent_program_name = l_concurrent_program_name;
119:
120: l_stmt_num := 40;
121: UPDATE /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
122: mtl_material_transactions MMT
123: SET transaction_group_id = NULL,
124: last_update_date = SYSDATE,
125: last_updated_by = l_last_updated_by,
126: last_update_login = l_last_update_login,

Line 153: UPDATE mtl_material_transactions mmt

149: /* VALIDATION 7,10: Interorg txns should not be from and to the same org. */
150: l_error_code := 'CST_INVALID_INTERORG';
151: FND_MESSAGE.set_name('BOM', l_error_code);
152: l_error_expl := FND_MESSAGE.Get;
153: UPDATE mtl_material_transactions mmt
154: SET costed_flag = 'E',
155: error_code = l_error_code,
156: error_explanation = l_error_expl,
157: last_update_date = SYSDATE,

Line 173: UPDATE mtl_material_transactions mmt

169: /* VALIDATION 3,4,5: Txfr txns should have all txfr columns populated. */
170: l_error_code := 'CST_INVALID_TXFR';
171: FND_MESSAGE.set_name('BOM', l_error_code);
172: l_error_expl := FND_MESSAGE.Get;
173: UPDATE mtl_material_transactions mmt
174: SET costed_flag = 'E',
175: error_code = l_error_code,
176: error_explanation = l_error_expl,
177: last_update_date = SYSDATE,

Line 206: UPDATE /+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) / mtl_material_transactions mmt

202: l_error_expl := FND_MESSAGE.Get;
203:
204: l_stmt_num := 72;
205:
206: UPDATE /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */ mtl_material_transactions mmt
207: SET costed_flag = 'E',
208: error_code = l_error_code,
209: error_explanation = l_error_expl,
210: last_update_date = SYSDATE,

Line 243: UPDATE mtl_material_transactions mmt

239: /* ignore scrap, wip/inv lot transactions, periodic cost update, pack/unpack, container */
240: l_error_code := 'CST_INVALID_CG';
241: FND_MESSAGE.set_name('BOM', l_error_code);
242: l_error_expl := FND_MESSAGE.Get;
243: UPDATE mtl_material_transactions mmt
244: SET costed_flag = 'E',
245: error_code = l_error_code,
246: error_explanation = l_error_expl,
247: last_update_date = SYSDATE,

Line 273: UPDATE mtl_material_transactions mmt

269: /* VALIDATION 6,9,12: Txfr CG validation in org (non null, must be in ccga or default). */
270: l_error_code := 'CST_MATCH_TXFR_CG_ORG';
271: FND_MESSAGE.set_name('BOM', l_error_code);
272: l_error_expl := FND_MESSAGE.Get;
273: UPDATE mtl_material_transactions mmt
274: SET costed_flag = 'E',
275: error_code = l_error_code,
276: error_explanation = l_error_expl,
277: last_update_date = SYSDATE,

Line 306: UPDATE mtl_material_transactions mmt

302: /* VALIDATION 8,11: Txfr CG validation in txfr org (non null, must be in ccga or default). */
303: l_error_code := 'CST_MATCH_TXFR_CG_TXFR_ORG';
304: FND_MESSAGE.set_name('BOM', l_error_code);
305: l_error_expl := FND_MESSAGE.Get;
306: UPDATE mtl_material_transactions mmt
307: SET costed_flag = 'E',
308: error_code = l_error_code,
309: error_explanation = l_error_expl,
310: last_update_date = SYSDATE,

Line 339: UPDATE mtl_material_transactions mmt

335: /* VALIDATION 13: make sure that acct alias is valid */
336: l_error_code := 'CST_INVALID_ACCT_ALIAS';
337: FND_MESSAGE.set_name('BOM', l_error_code);
338: l_error_expl := FND_MESSAGE.Get;
339: UPDATE mtl_material_transactions mmt
340: SET costed_flag = 'E',
341: error_code = l_error_code,
342: error_explanation = l_error_expl,
343: last_update_date = SYSDATE,

Line 364: UPDATE mtl_material_transactions mmt

360: /* VALIDATION 14: Issues and receipts should have valid subinventories. */
361: l_error_code := 'CST_INVALID_SUB';
362: FND_MESSAGE.set_name('BOM', l_error_code);
363: l_error_expl := FND_MESSAGE.Get;
364: UPDATE mtl_material_transactions mmt
365: SET costed_flag = 'E',
366: error_code = l_error_code,
367: error_explanation = l_error_expl,
368: last_update_date = SYSDATE,

Line 388: UPDATE mtl_material_transactions mmt

384: /* VALIDATION 15, 16: WIP transactions should refer to valid wip entity and be in wpb. */
385: l_error_code := 'CST_INVALID_WIP';
386: FND_MESSAGE.set_name('BOM', l_error_code);
387: l_error_expl := FND_MESSAGE.Get;
388: UPDATE mtl_material_transactions mmt
389: SET costed_flag = 'E',
390: error_code = l_error_code,
391: error_explanation = l_error_expl,
392: last_update_date = SYSDATE,

Line 418: UPDATE mtl_material_transactions mmt

414: /* VALIDATION 17: txn date not less than job/schedule release date */
415: l_error_code := 'CST_INVALID_JOB_DATE';
416: FND_MESSAGE.set_name('BOM', l_error_code);
417: l_error_expl := FND_MESSAGE.Get;
418: UPDATE mtl_material_transactions mmt
419: SET costed_flag = 'E',
420: error_code = l_error_code,
421: error_explanation = l_error_expl,
422: last_update_date = SYSDATE,