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 3711: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'

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

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

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

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

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

Line 4490: from mtl_system_items_b_kfv

4486: THEN
4487: -- dbms_output.put_line('select from mtl_system_items using inventory_item_id of '|| g_samples_table(i).inventory_item_id);
4488: -- dbms_output.put_line('filling in missing data');
4489: select concatenated_segments into g_samples_table(i).item_number
4490: from mtl_system_items_b_kfv
4491: where inventory_item_id = g_samples_table(i).inventory_item_id
4492: and organization_id = g_samples_table(i).organization_id;
4493: END IF;
4494:

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

4954: IF (p_from_item_number IS NOT NULL OR p_to_item_number IS NOT NULL ) THEN
4955: g_from_item_number := p_from_item_number;
4956: g_to_item_number := p_to_item_number;
4957: main_where_clause := main_where_clause
4958: ||' AND gs.inventory_item_id IN (SELECT inventory_item_id FROM mtl_system_items_b_kfv'
4959: ||' WHERE concatenated_segments BETWEEN :from_item_number AND :to_item_number'
4960: ||' AND organization_id = gs.owner_organization_id)';
4961: main_using_clause := main_using_clause||', gmd_outbound_apis_pub.g_from_item_number, gmd_outbound_apis_pub.g_to_item_number';
4962: END IF; -- (p_from_item_number IS NOT NULL OR p_to_item_number IS NOT NULL )