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.EGO_POST_PROCESS_MESSAGE_PVT dependencies on MTL_ITEM_BULKLOAD_RECS

Line 37: l_current_bundle_id MTL_ITEM_BULKLOAD_RECS.BUNDLE_ID%TYPE;

33: l_bundles_processed_count NUMBER;
34: l_remaining_bundles_count NUMBER;
35: l_current_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;
36: l_previous_message_id EGO_UCCNET_EVENTS.MESSAGE_ID%TYPE;
37: l_current_bundle_id MTL_ITEM_BULKLOAD_RECS.BUNDLE_ID%TYPE;
38:
39: EGO_NO_BUNDLES_IN_COLLECTION EXCEPTION;
40: PRAGMA EXCEPTION_INIT( EGO_NO_BUNDLES_IN_COLLECTION, -20000 );
41:

Line 86: MTL_ITEM_BULKLOAD_RECS mibr

82: FROM
83: FND_LOOKUP_VALUES corrective_action_lkup,
84: FND_LOOKUP_VALUES status_lkup,
85: EGO_UCCNET_ADD_CIC_INFO euaci,
86: MTL_ITEM_BULKLOAD_RECS mibr
87: WHERE
88: corrective_action_lkup.LANGUAGE (+) = c_language_code
89: AND corrective_action_lkup.ENABLED_FLAG (+) = 'Y'
90: AND ( corrective_action_lkup.END_DATE_ACTIVE IS NULL OR corrective_action_lkup.END_DATE_ACTIVE > SYSDATE )

Line 142: MTL_ITEM_BULKLOAD_RECS mibr

138: FROM
139: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
140: mibr.BUNDLE_ID BUNDLE_ID
141: FROM EGO_UCCNET_EVENTS eue,
142: MTL_ITEM_BULKLOAD_RECS mibr
143: WHERE
144: eue.CLN_ID = mibr.BUNDLE_ID
145: AND mibr.BUNDLE_COLLECTION_ID = c_bundle_collection_id
146: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID

Line 301: MTL_ITEM_BULKLOAD_RECS mibr

297: FROM
298: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
299: mibr.BUNDLE_ID BUNDLE_ID
300: FROM EGO_UCCNET_EVENTS eue,
301: MTL_ITEM_BULKLOAD_RECS mibr
302: WHERE
303: eue.CLN_ID = mibr.BUNDLE_ID
304: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
305: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID

Line 386: MTL_ITEM_BULKLOAD_RECS mibr

382: FROM
383: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
384: mibr.BUNDLE_ID BUNDLE_ID
385: FROM EGO_UCCNET_EVENTS eue,
386: MTL_ITEM_BULKLOAD_RECS mibr
387: WHERE
388: eue.CLN_ID = mibr.BUNDLE_ID
389: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
390: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID

Line 393: MTL_ITEM_BULKLOAD_RECS mibr

389: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
390: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID
391: ORDER BY eue.MESSAGE_ID, mibr.BUNDLE_ID )
392: WHERE ROWNUM < ( p_start_index + p_bundles_window_size ) ) selected_bundles,
393: MTL_ITEM_BULKLOAD_RECS mibr
394: WHERE
395: mibr.BUNDLE_ID = selected_bundles.BUNDLE_ID
396: AND selected_bundles.RN BETWEEN p_start_index AND ( p_start_index + p_bundles_window_size - 1 )
397: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value ) );

Line 413: MTL_ITEM_BULKLOAD_RECS mibr

409: FROM
410: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
411: mibr.BUNDLE_ID BUNDLE_ID
412: FROM EGO_UCCNET_EVENTS eue,
413: MTL_ITEM_BULKLOAD_RECS mibr
414: WHERE
415: eue.CLN_ID = mibr.BUNDLE_ID
416: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
417: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID

Line 420: MTL_ITEM_BULKLOAD_RECS mibr_outer

416: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
417: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID
418: ORDER BY eue.MESSAGE_ID, mibr.BUNDLE_ID )
419: WHERE ROWNUM < ( p_start_index + p_bundles_window_size ) ) selected_bundles,
420: MTL_ITEM_BULKLOAD_RECS mibr_outer
421: WHERE
422: mibr_outer.BUNDLE_ID = selected_bundles.BUNDLE_ID
423: AND selected_bundles.RN BETWEEN p_start_index AND ( p_start_index + p_bundles_window_size - 1 )
424: AND mibr_outer.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value ) );

Line 441: MTL_ITEM_BULKLOAD_RECS mibr

437: FROM
438: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
439: mibr.BUNDLE_ID BUNDLE_ID
440: FROM EGO_UCCNET_EVENTS eue,
441: MTL_ITEM_BULKLOAD_RECS mibr
442: WHERE
443: eue.CLN_ID = mibr.BUNDLE_ID
444: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
445: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID

Line 448: MTL_ITEM_BULKLOAD_RECS mibr

444: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
445: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID
446: ORDER BY eue.MESSAGE_ID, mibr.BUNDLE_ID )
447: WHERE ROWNUM < ( p_start_index + p_bundles_window_size ) ) selected_bundles,
448: MTL_ITEM_BULKLOAD_RECS mibr
449: WHERE
450: mibr.BUNDLE_ID = selected_bundles.BUNDLE_ID
451: AND selected_bundles.RN BETWEEN p_start_index AND ( p_start_index + p_bundles_window_size - 1 )
452: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value ) );

Line 468: MTL_ITEM_BULKLOAD_RECS mibr

464: FROM
465: ( SELECT eue.MESSAGE_ID MESSAGE_ID,
466: mibr.BUNDLE_ID BUNDLE_ID
467: FROM EGO_UCCNET_EVENTS eue,
468: MTL_ITEM_BULKLOAD_RECS mibr
469: WHERE
470: eue.CLN_ID = mibr.BUNDLE_ID
471: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
472: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID

Line 475: MTL_ITEM_BULKLOAD_RECS mibr_outer

471: AND mibr.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value )
472: GROUP BY eue.MESSAGE_ID, mibr.BUNDLE_ID
473: ORDER BY eue.MESSAGE_ID, mibr.BUNDLE_ID )
474: WHERE ROWNUM < ( p_start_index + p_bundles_window_size ) ) selected_bundles,
475: MTL_ITEM_BULKLOAD_RECS mibr_outer
476: WHERE
477: mibr_outer.BUNDLE_ID = selected_bundles.BUNDLE_ID
478: AND selected_bundles.RN BETWEEN p_start_index AND ( p_start_index + p_bundles_window_size - 1 )
479: AND mibr_outer.BUNDLE_COLLECTION_ID = TO_NUMBER ( p_pk1_value ) );