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.GMI_ITEM_PUB dependencies on IC_ITEM_MST

Line 36: ( item_no ic_item_mst.item_no%TYPE

32: -- Notes
33: --
34: -- API specific parameters to be presented in SQL RECORD format
35: TYPE item_rec_typ IS RECORD
36: ( item_no ic_item_mst.item_no%TYPE
37: , item_desc1 ic_item_mst.item_desc1%TYPE
38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL

Line 37: , item_desc1 ic_item_mst.item_desc1%TYPE

33: --
34: -- API specific parameters to be presented in SQL RECORD format
35: TYPE item_rec_typ IS RECORD
36: ( item_no ic_item_mst.item_no%TYPE
37: , item_desc1 ic_item_mst.item_desc1%TYPE
38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE

Line 38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL

34: -- API specific parameters to be presented in SQL RECORD format
35: TYPE item_rec_typ IS RECORD
36: ( item_no ic_item_mst.item_no%TYPE
37: , item_desc1 ic_item_mst.item_desc1%TYPE
38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0

Line 39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL

35: TYPE item_rec_typ IS RECORD
36: ( item_no ic_item_mst.item_no%TYPE
37: , item_desc1 ic_item_mst.item_desc1%TYPE
38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL

Line 40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL

36: ( item_no ic_item_mst.item_no%TYPE
37: , item_desc1 ic_item_mst.item_desc1%TYPE
38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0

Line 41: , item_um ic_item_mst.item_um%TYPE

37: , item_desc1 ic_item_mst.item_desc1%TYPE
38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0

Line 42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0

38: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL

Line 43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL

39: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0

Line 44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0

40: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0

Line 45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0

41: , item_um ic_item_mst.item_um%TYPE
42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0

Line 46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL

42: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0

Line 47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0

43: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0

Line 48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0

44: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3

Line 49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0

45: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0

Line 50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0

46: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL

Line 51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0

47: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0

Line 52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3

48: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0

Line 53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0

49: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL

Line 54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL

50: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL

Line 55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0

51: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL

Line 56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0

52: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL

Line 57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL

53: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL

Line 58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL

54: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL

Line 59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL

55: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL

Line 60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL

56: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL

Line 61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL

57: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL

Line 62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL

58: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL

Line 63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL

59: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL

Line 64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL

60: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL

Line 65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL

61: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL

Line 66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL

62: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL

Line 67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL

63: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL

Line 68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL

64: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL

Line 69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL

65: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0

Line 70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL

66: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0

Line 71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL

67: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL

Line 72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL

68: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL

Line 73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0

69: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL

Line 74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0

70: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL

Line 75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL

71: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL

Line 76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL

72: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL

Line 77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL

73: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL

Line 78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL

74: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0

Line 79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL

75: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL

Line 80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL

76: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0

Line 81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL

77: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0

Line 82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0

78: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL

Line 83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL

79: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0

Line 84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0

80: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88: , exported_date ic_item_mst.exported_date%TYPE

Line 85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0

81: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88: , exported_date ic_item_mst.exported_date%TYPE
89: DEFAULT TO_DATE('02011970','DDMMYYYY')

Line 86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL

82: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88: , exported_date ic_item_mst.exported_date%TYPE
89: DEFAULT TO_DATE('02011970','DDMMYYYY')
90: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL

Line 87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0

83: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88: , exported_date ic_item_mst.exported_date%TYPE
89: DEFAULT TO_DATE('02011970','DDMMYYYY')
90: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
91: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL

Line 88: , exported_date ic_item_mst.exported_date%TYPE

84: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
85: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88: , exported_date ic_item_mst.exported_date%TYPE
89: DEFAULT TO_DATE('02011970','DDMMYYYY')
90: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
91: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
92: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0

Line 90: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL

86: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88: , exported_date ic_item_mst.exported_date%TYPE
89: DEFAULT TO_DATE('02011970','DDMMYYYY')
90: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
91: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
92: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
93: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL

Line 91: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL

87: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
88: , exported_date ic_item_mst.exported_date%TYPE
89: DEFAULT TO_DATE('02011970','DDMMYYYY')
90: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
91: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
92: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
93: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL

Line 94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL

90: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
91: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
92: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
93: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL

Line 95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL

91: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
92: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
93: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL

Line 96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL

92: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
93: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL

Line 97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL

93: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL

Line 98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL

94: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL

Line 99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL

95: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL

Line 100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL

96: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL

Line 101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL

97: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL

Line 102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL

98: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL

Line 103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL

99: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL

Line 104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL

100: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL

Line 105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL

101: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL

Line 106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL

102: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL

Line 107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL

103: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL

Line 108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL

104: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL

Line 109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL

105: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL

Line 110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL

106: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL

Line 111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL

107: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL

Line 112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL

108: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL

Line 113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL

109: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL

Line 114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL

110: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL

Line 115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL

111: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL

Line 116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL

112: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL

Line 117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL

113: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL

Line 118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL

114: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL

Line 119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL

115: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
123: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL

Line 120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL

116: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
123: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
124: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL

Line 121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL

117: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
123: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
124: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
125: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'

Line 122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL

118: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
123: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
124: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
125: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
126: );

Line 123: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL

119: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
123: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
124: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
125: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
126: );
127: --

Line 124: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL

120: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
121: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
122: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
123: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
124: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
125: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
126: );
127: --
128: PROCEDURE Create_Item