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_B_KFV

Line 288: FROM mtl_system_items_b_kfv

284: IF g_test_methods_table(i).test_kit_inv_item_id IS NOT NULL THEN --INVCONV
285: gme_debug.put_line('Retrieving test kit item for test kit inv item id:'
286: ||to_char(g_test_methods_table(i).test_kit_inv_item_id));
287: SELECT concatenated_segments INTO g_test_methods_table(i).test_kit_item_number
288: FROM mtl_system_items_b_kfv
289: WHERE organization_id = g_test_methods_table(i).test_kit_organization_id
290: AND inventory_item_id = g_test_methods_table(i).test_kit_inv_item_id;
291: END IF;
292:

Line 1141: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

1137: THEN
1138: g_from_item_number := p_from_item_number;
1139: g_to_item_number := p_to_item_number;
1140: main_where_clause := main_where_clause
1141: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
1142: ||' WHERE concatenated_segments BETWEEN :from_item_number AND :to_item_number'
1143: ||' AND organization_id = gs.owner_organization_id)';
1144: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_from_item_number, gmd_outbound_apis_pub.g_to_item_number';
1145: ELSIF p_from_item_number IS NOT NULL

Line 1149: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

1145: ELSIF p_from_item_number IS NOT NULL
1146: THEN
1147: g_from_item_number := p_from_item_number;
1148: main_where_clause := main_where_clause
1149: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
1150: ||' WHERE concatenated_segments >= :from_item_number'
1151: ||' AND organization_id = gs.owner_organization_id)';
1152: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_from_item_number';
1153: ELSIF p_to_item_number IS NOT NULL

Line 1157: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

1153: ELSIF p_to_item_number IS NOT NULL
1154: THEN
1155: g_to_item_number := p_to_item_number;
1156: main_where_clause := main_where_clause
1157: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
1158: ||' WHERE concatenated_segments <= :to_item_number'
1159: ||' AND organization_id = gs.owner_organization_id)';
1160: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_to_item_number';
1161: END IF;

Line 2308: ||' mtl_system_items_b_kfv WHERE concatenated_segments = :inv_vr_item_number'

2304: g_inv_vr_item_number := p_inv_vr_item_number;
2305: main_where_clause := main_where_clause||' AND mivr.lot_number IN'
2306: ||' (SELECT l.lot_number FROM mtl_lot_numbers l'
2307: ||' WHERE l.organization_id IN (SELECT organization_id FROM'
2308: ||' mtl_system_items_b_kfv WHERE concatenated_segments = :inv_vr_item_number'
2309: ||' AND inventory_item_id = l.inventory_item_id))';
2310:
2311: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_inv_vr_item_number';
2312:

Line 2316: ||' mtl_system_items_b_kfv WHERE concatenated_segments = :inv_vr_item_number'

2312:
2313: inv_vr_where_clause := inv_vr_where_clause||' AND ivr.lot_number IN'
2314: ||' (SELECT l.lot_number FROM mtl_lot_numbers l'
2315: ||' WHERE l.organization_id IN (SELECT organization_id FROM'
2316: ||' mtl_system_items_b_kfv WHERE concatenated_segments = :inv_vr_item_number'
2317: ||' AND inventory_item_id = l.inventory_item_id))';
2318: inv_vr_using_clause := inv_vr_using_clause||', gmd_outbound_apis_pub.g_inv_vr_item_number';
2319: END IF;
2320:

Line 2712: FROM mtl_system_items_b_kfv

2708: LOOP
2709: IF g_specifications_table(i).owner_organization_id IS NOT NULL
2710: AND g_specifications_table(i).inventory_item_id IS NOT NULL THEN
2711: SELECT concatenated_segments INTO g_specifications_table(i).item_number
2712: FROM mtl_system_items_b_kfv
2713: WHERE organization_id = g_specifications_table(i).owner_organization_id
2714: AND inventory_item_id = g_specifications_table(i).inventory_item_id;
2715: END IF;
2716: END LOOP;

Line 3709: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

3705: THEN
3706: g_from_item_number := p_from_item_number;
3707: g_to_item_number := p_to_item_number;
3708: where_clause := where_clause
3709: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
3710: ||' WHERE concatenated_segments BETWEEN :from_item_number AND :to_item_number'
3711: ||' AND organization_id = gs.organization_id)'; -- 5335829 rework - owner_organization_id is not a valid column name
3712: using_clause := using_clause||', gmd_outbound_apis_pub.g_from_item_number, gmd_outbound_apis_pub.g_to_item_number';
3713: ELSIF p_from_item_number IS NOT NULL

Line 3717: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

3713: ELSIF p_from_item_number IS NOT NULL
3714: THEN
3715: g_from_item_number := p_from_item_number;
3716: where_clause := where_clause
3717: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
3718: ||' WHERE concatenated_segments >= :from_item_number'
3719: ||' AND organization_id = gs.organization_id)'; -- 5335829 rework - owner_organization_id is not a valid column name
3720: using_clause := using_clause||', gmd_outbound_apis_pub.g_from_item_number';
3721: ELSIF p_to_item_number IS NOT NULL

Line 3725: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

3721: ELSIF p_to_item_number IS NOT NULL
3722: THEN
3723: g_to_item_number := p_to_item_number;
3724: where_clause := where_clause
3725: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
3726: ||' WHERE concatenated_segments <= :to_item_number'
3727: ||' AND organization_id = gs.organization_id)'; -- 5335829 rework - owner_organization_id is not a valid column name
3728: using_clause := using_clause||', gmd_outbound_apis_pub.g_to_item_number';
3729: END IF; -- IF p_from_item_number IS NOT NULL and p_to_item_number IS NOT NULL

Line 4463: from mtl_system_items_b_kfv

4459: THEN
4460: -- dbms_output.put_line('select from mtl_system_items using inventory_item_id of '|| g_samples_table(i).inventory_item_id);
4461: -- dbms_output.put_line('filling in missing data');
4462: select concatenated_segments into g_samples_table(i).item_number
4463: from mtl_system_items_b_kfv
4464: where inventory_item_id = g_samples_table(i).inventory_item_id
4465: and organization_id = g_samples_table(i).organization_id;
4466: END IF;
4467:

Line 4910: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

4906: IF (p_from_item_number IS NOT NULL OR p_to_item_number IS NOT NULL ) THEN
4907: g_from_item_number := p_from_item_number;
4908: g_to_item_number := p_to_item_number;
4909: main_where_clause := main_where_clause
4910: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
4911: ||' WHERE concatenated_segments BETWEEN :from_item_number AND :to_item_number'
4912: ||' AND organization_id = gs.owner_organization_id)';
4913: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_from_item_number, gmd_outbound_apis_pub.g_to_item_number';
4914: END IF; -- (p_from_item_number IS NOT NULL OR p_to_item_number IS NOT NULL )