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 147: UPDATE mtl_material_transactions mmt

143: /* VALIDATION 7,10: Interorg txns should not be from and to the same org. */
144: l_error_code := 'CST_INVALID_INTERORG';
145: FND_MESSAGE.set_name('BOM', l_error_code);
146: l_error_expl := FND_MESSAGE.Get;
147: UPDATE mtl_material_transactions mmt
148: SET costed_flag = 'E',
149: error_code = l_error_code,
150: error_explanation = l_error_expl,
151: last_update_date = SYSDATE,

Line 167: UPDATE mtl_material_transactions mmt

163: /* VALIDATION 3,4,5: Txfr txns should have all txfr columns populated. */
164: l_error_code := 'CST_INVALID_TXFR';
165: FND_MESSAGE.set_name('BOM', l_error_code);
166: l_error_expl := FND_MESSAGE.Get;
167: UPDATE mtl_material_transactions mmt
168: SET costed_flag = 'E',
169: error_code = l_error_code,
170: error_explanation = l_error_expl,
171: last_update_date = SYSDATE,

Line 216: UPDATE mtl_material_transactions mmt

212: l_timezone_offset := INV_LE_TIMEZONE_PUB.GET_SERVER_DAY_TIME_FOR_LE(SYSDATE, l_legal_entity) - SYSDATE;
213:
214: l_stmt_num := 72;
215:
216: UPDATE mtl_material_transactions mmt
217: SET costed_flag = 'E',
218: error_code = l_error_code,
219: error_explanation = l_error_expl,
220: last_update_date = SYSDATE,

Line 248: UPDATE mtl_material_transactions mmt

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

Line 278: UPDATE mtl_material_transactions mmt

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

Line 311: UPDATE mtl_material_transactions mmt

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

Line 344: UPDATE mtl_material_transactions mmt

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

Line 369: UPDATE mtl_material_transactions mmt

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

Line 393: UPDATE mtl_material_transactions mmt

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

Line 423: UPDATE mtl_material_transactions mmt

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