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.XNB_ITEM_BATCH_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 19: item_name mtl_system_items_b.segment1%TYPE,

15: --The Item export record
16: TYPE g_items_record IS RECORD
17: (
18: item_id NUMBER,
19: item_name mtl_system_items_b.segment1%TYPE,
20: bom_item_type mtl_system_items_b.bom_item_type%TYPE,
21: bom_itype_desc mfg_lookups.Meaning%TYPE,
22: unit_of_measure mtl_system_items_b.primary_unit_of_measure%TYPE,
23: description mtl_system_items_b.description%TYPE,

Line 20: bom_item_type mtl_system_items_b.bom_item_type%TYPE,

16: TYPE g_items_record IS RECORD
17: (
18: item_id NUMBER,
19: item_name mtl_system_items_b.segment1%TYPE,
20: bom_item_type mtl_system_items_b.bom_item_type%TYPE,
21: bom_itype_desc mfg_lookups.Meaning%TYPE,
22: unit_of_measure mtl_system_items_b.primary_unit_of_measure%TYPE,
23: description mtl_system_items_b.description%TYPE,
24: status_code mtl_system_items_b.inventory_item_status_code%TYPE,

Line 22: unit_of_measure mtl_system_items_b.primary_unit_of_measure%TYPE,

18: item_id NUMBER,
19: item_name mtl_system_items_b.segment1%TYPE,
20: bom_item_type mtl_system_items_b.bom_item_type%TYPE,
21: bom_itype_desc mfg_lookups.Meaning%TYPE,
22: unit_of_measure mtl_system_items_b.primary_unit_of_measure%TYPE,
23: description mtl_system_items_b.description%TYPE,
24: status_code mtl_system_items_b.inventory_item_status_code%TYPE,
25: status_desc mtl_item_status.description%TYPE,
26: item_type mtl_system_items_b.item_type%TYPE,

Line 23: description mtl_system_items_b.description%TYPE,

19: item_name mtl_system_items_b.segment1%TYPE,
20: bom_item_type mtl_system_items_b.bom_item_type%TYPE,
21: bom_itype_desc mfg_lookups.Meaning%TYPE,
22: unit_of_measure mtl_system_items_b.primary_unit_of_measure%TYPE,
23: description mtl_system_items_b.description%TYPE,
24: status_code mtl_system_items_b.inventory_item_status_code%TYPE,
25: status_desc mtl_item_status.description%TYPE,
26: item_type mtl_system_items_b.item_type%TYPE,
27: item_type_desc fnd_lookup_values_vl.Meaning%TYPE,

Line 24: status_code mtl_system_items_b.inventory_item_status_code%TYPE,

20: bom_item_type mtl_system_items_b.bom_item_type%TYPE,
21: bom_itype_desc mfg_lookups.Meaning%TYPE,
22: unit_of_measure mtl_system_items_b.primary_unit_of_measure%TYPE,
23: description mtl_system_items_b.description%TYPE,
24: status_code mtl_system_items_b.inventory_item_status_code%TYPE,
25: status_desc mtl_item_status.description%TYPE,
26: item_type mtl_system_items_b.item_type%TYPE,
27: item_type_desc fnd_lookup_values_vl.Meaning%TYPE,
28: item_class mtl_system_items_b.primary_uom_code%TYPE,

Line 26: item_type mtl_system_items_b.item_type%TYPE,

22: unit_of_measure mtl_system_items_b.primary_unit_of_measure%TYPE,
23: description mtl_system_items_b.description%TYPE,
24: status_code mtl_system_items_b.inventory_item_status_code%TYPE,
25: status_desc mtl_item_status.description%TYPE,
26: item_type mtl_system_items_b.item_type%TYPE,
27: item_type_desc fnd_lookup_values_vl.Meaning%TYPE,
28: item_class mtl_system_items_b.primary_uom_code%TYPE,
29: start_date mtl_system_items_b.start_date_active%TYPE,
30: end_date mtl_system_items_b.end_date_active%TYPE,

Line 28: item_class mtl_system_items_b.primary_uom_code%TYPE,

24: status_code mtl_system_items_b.inventory_item_status_code%TYPE,
25: status_desc mtl_item_status.description%TYPE,
26: item_type mtl_system_items_b.item_type%TYPE,
27: item_type_desc fnd_lookup_values_vl.Meaning%TYPE,
28: item_class mtl_system_items_b.primary_uom_code%TYPE,
29: start_date mtl_system_items_b.start_date_active%TYPE,
30: end_date mtl_system_items_b.end_date_active%TYPE,
31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,

Line 29: start_date mtl_system_items_b.start_date_active%TYPE,

25: status_desc mtl_item_status.description%TYPE,
26: item_type mtl_system_items_b.item_type%TYPE,
27: item_type_desc fnd_lookup_values_vl.Meaning%TYPE,
28: item_class mtl_system_items_b.primary_uom_code%TYPE,
29: start_date mtl_system_items_b.start_date_active%TYPE,
30: end_date mtl_system_items_b.end_date_active%TYPE,
31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,

Line 30: end_date mtl_system_items_b.end_date_active%TYPE,

26: item_type mtl_system_items_b.item_type%TYPE,
27: item_type_desc fnd_lookup_values_vl.Meaning%TYPE,
28: item_class mtl_system_items_b.primary_uom_code%TYPE,
29: start_date mtl_system_items_b.start_date_active%TYPE,
30: end_date mtl_system_items_b.end_date_active%TYPE,
31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,

Line 31: attribute1 mtl_system_items_b.attribute1%TYPE,

27: item_type_desc fnd_lookup_values_vl.Meaning%TYPE,
28: item_class mtl_system_items_b.primary_uom_code%TYPE,
29: start_date mtl_system_items_b.start_date_active%TYPE,
30: end_date mtl_system_items_b.end_date_active%TYPE,
31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,

Line 32: attribute2 mtl_system_items_b.attribute2%TYPE,

28: item_class mtl_system_items_b.primary_uom_code%TYPE,
29: start_date mtl_system_items_b.start_date_active%TYPE,
30: end_date mtl_system_items_b.end_date_active%TYPE,
31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,

Line 33: attribute3 mtl_system_items_b.attribute3%TYPE,

29: start_date mtl_system_items_b.start_date_active%TYPE,
30: end_date mtl_system_items_b.end_date_active%TYPE,
31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,

Line 34: attribute4 mtl_system_items_b.attribute4%TYPE,

30: end_date mtl_system_items_b.end_date_active%TYPE,
31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,

Line 35: attribute5 mtl_system_items_b.attribute5%TYPE,

31: attribute1 mtl_system_items_b.attribute1%TYPE,
32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,

Line 36: attribute6 mtl_system_items_b.attribute6%TYPE,

32: attribute2 mtl_system_items_b.attribute2%TYPE,
33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,

Line 37: attribute7 mtl_system_items_b.attribute7%TYPE,

33: attribute3 mtl_system_items_b.attribute3%TYPE,
34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,

Line 38: attribute8 mtl_system_items_b.attribute8%TYPE,

34: attribute4 mtl_system_items_b.attribute4%TYPE,
35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,

Line 39: attribute9 mtl_system_items_b.attribute9%TYPE,

35: attribute5 mtl_system_items_b.attribute5%TYPE,
36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,
43: attribute13 mtl_system_items_b.attribute13%TYPE,

Line 40: attribute10 mtl_system_items_b.attribute10%TYPE,

36: attribute6 mtl_system_items_b.attribute6%TYPE,
37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,
43: attribute13 mtl_system_items_b.attribute13%TYPE,
44: attribute14 mtl_system_items_b.attribute14%TYPE,

Line 41: attribute11 mtl_system_items_b.attribute11%TYPE,

37: attribute7 mtl_system_items_b.attribute7%TYPE,
38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,
43: attribute13 mtl_system_items_b.attribute13%TYPE,
44: attribute14 mtl_system_items_b.attribute14%TYPE,
45: attribute15 mtl_system_items_b.attribute15%TYPE

Line 42: attribute12 mtl_system_items_b.attribute12%TYPE,

38: attribute8 mtl_system_items_b.attribute8%TYPE,
39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,
43: attribute13 mtl_system_items_b.attribute13%TYPE,
44: attribute14 mtl_system_items_b.attribute14%TYPE,
45: attribute15 mtl_system_items_b.attribute15%TYPE
46: );

Line 43: attribute13 mtl_system_items_b.attribute13%TYPE,

39: attribute9 mtl_system_items_b.attribute9%TYPE,
40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,
43: attribute13 mtl_system_items_b.attribute13%TYPE,
44: attribute14 mtl_system_items_b.attribute14%TYPE,
45: attribute15 mtl_system_items_b.attribute15%TYPE
46: );
47:

Line 44: attribute14 mtl_system_items_b.attribute14%TYPE,

40: attribute10 mtl_system_items_b.attribute10%TYPE,
41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,
43: attribute13 mtl_system_items_b.attribute13%TYPE,
44: attribute14 mtl_system_items_b.attribute14%TYPE,
45: attribute15 mtl_system_items_b.attribute15%TYPE
46: );
47:
48: --Reference cursor for the dynamic sql

Line 45: attribute15 mtl_system_items_b.attribute15%TYPE

41: attribute11 mtl_system_items_b.attribute11%TYPE,
42: attribute12 mtl_system_items_b.attribute12%TYPE,
43: attribute13 mtl_system_items_b.attribute13%TYPE,
44: attribute14 mtl_system_items_b.attribute14%TYPE,
45: attribute15 mtl_system_items_b.attribute15%TYPE
46: );
47:
48: --Reference cursor for the dynamic sql
49: TYPE g_items_cursor IS REF CURSOR;