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.GMD_OUTBOUND_APIS_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 2784: SELECT concatenated_segments FROM mtl_system_items_kfv

2780: i NUMBER;
2781:
2782:
2783: CURSOR item_cursor (cp_inventory_item_id NUMBER) IS
2784: SELECT concatenated_segments FROM mtl_system_items_kfv
2785: WHERE inventory_item_id = cp_inventory_item_id;
2786:
2787: l_api_name VARCHAR2(100) := 'fetch_results';
2788:

Line 3071: gme_debug.put_line('select from mtl_system_items_kfv using inventory_item_id of '|| g_results_table(i).test_kit_inv_item_id);

3067: LOOP
3068:
3069: IF g_results_table(i).test_kit_inv_item_id IS NOT NULL
3070: THEN
3071: gme_debug.put_line('select from mtl_system_items_kfv using inventory_item_id of '|| g_results_table(i).test_kit_inv_item_id);
3072: SELECT concatenated_segments
3073: INTO g_results_table(i).test_kit_inv_item_number
3074: FROM mtl_system_items_kfv
3075: WHERE inventory_item_id = g_results_table(i).test_kit_inv_item_id

Line 3074: FROM mtl_system_items_kfv

3070: THEN
3071: gme_debug.put_line('select from mtl_system_items_kfv using inventory_item_id of '|| g_results_table(i).test_kit_inv_item_id);
3072: SELECT concatenated_segments
3073: INTO g_results_table(i).test_kit_inv_item_number
3074: FROM mtl_system_items_kfv
3075: WHERE inventory_item_id = g_results_table(i).test_kit_inv_item_id
3076: and rownum = 1; -- 5346480 rework
3077: END IF;
3078:

Line 3193: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '

3189: ||'gcr.last_update_date, gcr.last_updated_by, fu2.user_name, '
3190: ||'gcr.last_update_login, gcr.PARENT_COMPOSITE_RESULT_ID) '; -- 5346713
3191:
3192: table_list := 'FROM gmd_composite_results gcr, gmd_sampling_events gse, gmd_event_spec_disp gesd, '
3193: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '
3194: ||'fnd_user fu1, fnd_user fu2 ';
3195:
3196:
3197: where_clause := 'WHERE gse.sampling_event_id = gesd.sampling_event_id '

Line 3226: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '

3222: ||'gcr.last_update_date, gcr.last_updated_by, fu2.user_name, '
3223: ||'gcr.last_update_login, gcr.PARENT_COMPOSITE_RESULT_ID) '; -- 5346713
3224:
3225: table_list := 'FROM gmd_composite_results gcr, gmd_sampling_events gse, gmd_event_spec_disp gesd, '
3226: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '
3227: ||'fnd_user fu1, fnd_user fu2 ';
3228:
3229:
3230: where_clause := 'WHERE gse.sampling_event_id = gesd.sampling_event_id '

Line 3259: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '

3255: ||'gcr.last_update_date, gcr.last_updated_by, fu2.user_name, '
3256: ||'gcr.last_update_login, gcr.PARENT_COMPOSITE_RESULT_ID) '; -- 5347613
3257:
3258: table_list := 'FROM gmd_composite_results gcr, gmd_sampling_events gse, gmd_event_spec_disp gesd,'
3259: ||'gmd_composite_spec_disp gcsd, mtl_system_items_kfv msi, '
3260: ||'fnd_user fu1, fnd_user fu2 ';
3261:
3262:
3263: where_clause := 'WHERE gse.sampling_event_id = gesd.sampling_event_id '

Line 3326: where_clause := where_clause||'AND msi.inventory_item_id IN ( SELECT distinct inventory_item_id FROM mtl_system_items_kfv'

3322: -- BUG 3078607 correct using variable
3323: IF p_from_item_number IS NOT NULL /*NSRIVAST, INVCONV*/
3324: THEN
3325: gmd_outbound_apis_pub.g_from_item_no := p_from_item_number;
3326: where_clause := where_clause||'AND msi.inventory_item_id IN ( SELECT distinct inventory_item_id FROM mtl_system_items_kfv'
3327: ||' WHERE concatenated_segments >= :from_item_number'
3328: ||' AND organization_id = gse.organization_id)'; -- 5346713 rework added org id
3329:
3330: using_clause := using_clause||', gmd_outbound_apis_pub.g_from_item_no ';

Line 3336: where_clause := where_clause||'AND msi.inventory_item_id IN ( SELECT distinct inventory_item_id FROM mtl_system_items_kfv'

3332:
3333: IF p_to_item_number IS NOT NULL /*NSRIVAST, INVCONV*/
3334: THEN
3335: gmd_outbound_apis_pub.g_to_item_no := p_to_item_number;
3336: where_clause := where_clause||'AND msi.inventory_item_id IN ( SELECT distinct inventory_item_id FROM mtl_system_items_kfv'
3337: ||' WHERE concatenated_segments <= :to_item_number'
3338: ||' AND organization_id = gse.organization_id)'; -- 5346713 rework added org id
3339: using_clause := using_clause||', gmd_outbound_apis_pub.g_to_item_no ';
3340: END IF;

Line 3421: gme_debug.put_line('select from mtl_system_items_kfv using '|| g_composite_results_table(i).inventory_item_id);

3417: LOOP
3418: --gme_debug.put_line('inside internal loop i = ' || i);
3419: IF g_composite_results_table(i).inventory_item_id IS NOT NULL AND g_composite_results_table(i).item_number IS NULL
3420: THEN
3421: gme_debug.put_line('select from mtl_system_items_kfv using '|| g_composite_results_table(i).inventory_item_id);
3422: SELECT concatenated_segments INTO g_composite_results_table(i).item_number
3423: FROM mtl_system_items_kfv msi
3424: WHERE inventory_item_id = g_composite_results_table(i).inventory_item_id
3425: and rownum = 1 ; -- 5346713 rework

Line 3423: FROM mtl_system_items_kfv msi

3419: IF g_composite_results_table(i).inventory_item_id IS NOT NULL AND g_composite_results_table(i).item_number IS NULL
3420: THEN
3421: gme_debug.put_line('select from mtl_system_items_kfv using '|| g_composite_results_table(i).inventory_item_id);
3422: SELECT concatenated_segments INTO g_composite_results_table(i).item_number
3423: FROM mtl_system_items_kfv msi
3424: WHERE inventory_item_id = g_composite_results_table(i).inventory_item_id
3425: and rownum = 1 ; -- 5346713 rework
3426: END IF;
3427: