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

Line 50: ( item_no ic_item_mst.item_no%TYPE

46:
47:
48:
49: TYPE item_rec_typ IS RECORD
50: ( item_no ic_item_mst.item_no%TYPE
51: , item_desc1 ic_item_mst.item_desc1%TYPE
52: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL

Line 51: , item_desc1 ic_item_mst.item_desc1%TYPE

47:
48:
49: TYPE item_rec_typ IS RECORD
50: ( item_no ic_item_mst.item_no%TYPE
51: , item_desc1 ic_item_mst.item_desc1%TYPE
52: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE

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

48:
49: TYPE item_rec_typ IS RECORD
50: ( item_no ic_item_mst.item_no%TYPE
51: , item_desc1 ic_item_mst.item_desc1%TYPE
52: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0

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

49: TYPE item_rec_typ IS RECORD
50: ( item_no ic_item_mst.item_no%TYPE
51: , item_desc1 ic_item_mst.item_desc1%TYPE
52: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL

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

50: ( item_no ic_item_mst.item_no%TYPE
51: , item_desc1 ic_item_mst.item_desc1%TYPE
52: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0

Line 55: , item_um ic_item_mst.item_um%TYPE

51: , item_desc1 ic_item_mst.item_desc1%TYPE
52: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0

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

52: , item_desc2 ic_item_mst.item_desc2%TYPE DEFAULT NULL
53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL

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

53: , alt_itema ic_item_mst.alt_itema%TYPE DEFAULT NULL
54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0

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

54: , alt_itemb ic_item_mst.alt_itemb%TYPE DEFAULT NULL
55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0

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

55: , item_um ic_item_mst.item_um%TYPE
56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0

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

56: , dualum_ind ic_item_mst.dualum_ind%TYPE DEFAULT 0
57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0

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

57: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0

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

58: , deviation_lo ic_item_mst.deviation_lo%TYPE DEFAULT 0
59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3

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

59: , deviation_hi ic_item_mst.deviation_hi%TYPE DEFAULT 0
60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0

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

60: , level_code ic_item_mst.level_code%TYPE DEFAULT NULL
61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL

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

61: , lot_ctl ic_item_mst.lot_ctl%TYPE DEFAULT 0
62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0

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

62: , lot_indivisible ic_item_mst.lot_indivisible%TYPE DEFAULT 0
63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0

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

63: , sublot_ctl ic_item_mst.sublot_ctl%TYPE DEFAULT 0
64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL

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

64: , loct_ctl ic_item_mst.loct_ctl%TYPE DEFAULT 0
65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL

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

65: , noninv_ind ic_item_mst.noninv_ind%TYPE DEFAULT 0
66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL

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

66: , match_type ic_item_mst.match_type%TYPE DEFAULT 3
67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL

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

67: , inactive_ind ic_item_mst.inactive_ind%TYPE DEFAULT 0
68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL

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

68: , inv_type ic_item_mst.inv_type%TYPE DEFAULT NULL
69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL

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

69: , shelf_life ic_item_mst.shelf_life%TYPE DEFAULT 0
70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL

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

70: , retest_interval ic_item_mst.retest_interval%TYPE DEFAULT 0
71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL

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

71: , item_abccode ic_item_mst.item_abccode%TYPE DEFAULT NULL
72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL

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

72: , gl_class ic_item_mst.gl_class%TYPE DEFAULT NULL
73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL

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

73: , inv_class ic_item_mst.inv_class%TYPE DEFAULT NULL
74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL

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

74: , sales_class ic_item_mst.sales_class%TYPE DEFAULT NULL
75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL

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

75: , ship_class ic_item_mst.ship_class%TYPE DEFAULT NULL
76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL

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

76: , frt_class ic_item_mst.frt_class%TYPE DEFAULT NULL
77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL

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

77: , price_class ic_item_mst.price_class%TYPE DEFAULT NULL
78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL

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

78: , storage_class ic_item_mst.storage_class%TYPE DEFAULT NULL
79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL

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

79: , purch_class ic_item_mst.purch_class%TYPE DEFAULT NULL
80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0

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

80: , tax_class ic_item_mst.tax_class%TYPE DEFAULT NULL
81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0

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

81: , customs_class ic_item_mst.customs_class%TYPE DEFAULT NULL
82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL

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

82: , alloc_class ic_item_mst.alloc_class%TYPE DEFAULT NULL
83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL

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

83: , planning_class ic_item_mst.planning_class%TYPE DEFAULT NULL
84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL

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

84: , itemcost_class ic_item_mst.itemcost_class%TYPE DEFAULT NULL
85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL

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

85: , cost_mthd_code ic_item_mst.cost_mthd_code%TYPE DEFAULT NULL
86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL

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

86: , upc_code ic_item_mst.upc_code%TYPE DEFAULT NULL
87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL

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

87: , grade_ctl ic_item_mst.grade_ctl%TYPE DEFAULT 0
88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL

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

88: , status_ctl ic_item_mst.status_ctl%TYPE DEFAULT 0
89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0

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

89: , qc_grade ic_item_mst.qc_grade%TYPE DEFAULT NULL
90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL

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

90: , lot_status ic_item_mst.lot_status%TYPE DEFAULT NULL
91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0

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

91: , bulk_id ic_item_mst.bulk_id%TYPE DEFAULT NULL
92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0

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

92: , pkg_id ic_item_mst.pkg_id%TYPE DEFAULT NULL
93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL

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

93: , qcitem_no ic_item_mst.item_no%TYPE DEFAULT NULL
94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0

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

94: , qchold_res_code ic_item_mst.qchold_res_code%TYPE DEFAULT NULL
95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')

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

95: , expaction_code ic_item_mst.expaction_code%TYPE DEFAULT NULL
96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')
103: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL

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

96: , fill_qty ic_item_mst.fill_qty%TYPE DEFAULT 0
97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')
103: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
104: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL

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

97: , fill_um ic_item_mst.fill_um%TYPE DEFAULT NULL
98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')
103: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
104: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
105: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0

Line 102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')

98: , expaction_interval ic_item_mst.expaction_interval%TYPE DEFAULT 0
99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')
103: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
104: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
105: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
106: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0

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

99: , phantom_type ic_item_mst.phantom_type%TYPE DEFAULT 0
100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')
103: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
104: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
105: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
106: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
107: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL

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

100: , whse_item_no ic_item_mst.item_no%TYPE DEFAULT NULL
101: , experimental_ind ic_item_mst.experimental_ind%TYPE DEFAULT 0
102: , exported_date ic_item_mst.exported_date%TYPE DEFAULT TO_DATE('02011970','DDMMYYYY')
103: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
104: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
105: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
106: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
107: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
108: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL

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

103: , seq_dpnd_class ic_item_mst.seq_dpnd_class%TYPE DEFAULT NULL
104: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
105: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
106: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
107: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
108: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
109: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL

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

104: , commodity_code ic_item_mst.commodity_code%TYPE DEFAULT NULL
105: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
106: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
107: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
108: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
109: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL

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

105: , ic_matr_days ic_item_cpg.ic_matr_days%TYPE DEFAULT 0
106: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
107: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
108: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
109: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL

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

106: , ic_hold_days ic_item_cpg.ic_hold_days%TYPE DEFAULT 0
107: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
108: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
109: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL

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

107: , attribute1 ic_item_mst.attribute1%TYPE DEFAULT NULL
108: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
109: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL

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

108: , attribute2 ic_item_mst.attribute2%TYPE DEFAULT NULL
109: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL

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

109: , attribute3 ic_item_mst.attribute3%TYPE DEFAULT NULL
110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL

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

110: , attribute4 ic_item_mst.attribute4%TYPE DEFAULT NULL
111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL

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

111: , attribute5 ic_item_mst.attribute5%TYPE DEFAULT NULL
112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL

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

112: , attribute6 ic_item_mst.attribute6%TYPE DEFAULT NULL
113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL

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

113: , attribute7 ic_item_mst.attribute7%TYPE DEFAULT NULL
114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL

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

114: , attribute8 ic_item_mst.attribute8%TYPE DEFAULT NULL
115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL

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

115: , attribute9 ic_item_mst.attribute9%TYPE DEFAULT NULL
116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL

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

116: , attribute10 ic_item_mst.attribute10%TYPE DEFAULT NULL
117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL

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

117: , attribute11 ic_item_mst.attribute11%TYPE DEFAULT NULL
118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL

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

118: , attribute12 ic_item_mst.attribute12%TYPE DEFAULT NULL
119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL

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

119: , attribute13 ic_item_mst.attribute13%TYPE DEFAULT NULL
120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL

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

120: , attribute14 ic_item_mst.attribute14%TYPE DEFAULT NULL
121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL

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

121: , attribute15 ic_item_mst.attribute15%TYPE DEFAULT NULL
122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL

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

122: , attribute16 ic_item_mst.attribute16%TYPE DEFAULT NULL
123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL

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

123: , attribute17 ic_item_mst.attribute17%TYPE DEFAULT NULL
124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL

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

124: , attribute18 ic_item_mst.attribute18%TYPE DEFAULT NULL
125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL

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

125: , attribute19 ic_item_mst.attribute19%TYPE DEFAULT NULL
126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL

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

126: , attribute20 ic_item_mst.attribute20%TYPE DEFAULT NULL
127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL

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

127: , attribute21 ic_item_mst.attribute21%TYPE DEFAULT NULL
128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL

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

128: , attribute22 ic_item_mst.attribute22%TYPE DEFAULT NULL
129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL

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

129: , attribute23 ic_item_mst.attribute23%TYPE DEFAULT NULL
130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
137: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL

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

130: , attribute24 ic_item_mst.attribute24%TYPE DEFAULT NULL
131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
137: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
138: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'

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

131: , attribute25 ic_item_mst.attribute25%TYPE DEFAULT NULL
132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
137: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
138: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
139: , ont_pricing_qty_source ic_item_mst.ont_pricing_qty_source%TYPE DEFAULT 0

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

132: , attribute26 ic_item_mst.attribute26%TYPE DEFAULT NULL
133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
137: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
138: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
139: , ont_pricing_qty_source ic_item_mst.ont_pricing_qty_source%TYPE DEFAULT 0
140: , gl_business_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL

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

133: , attribute27 ic_item_mst.attribute27%TYPE DEFAULT NULL
134: , attribute28 ic_item_mst.attribute28%TYPE DEFAULT NULL
135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
137: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
138: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
139: , ont_pricing_qty_source ic_item_mst.ont_pricing_qty_source%TYPE DEFAULT 0
140: , gl_business_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
141: , gl_prod_line mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL

Line 139: , ont_pricing_qty_source ic_item_mst.ont_pricing_qty_source%TYPE DEFAULT 0

135: , attribute29 ic_item_mst.attribute29%TYPE DEFAULT NULL
136: , attribute30 ic_item_mst.attribute30%TYPE DEFAULT NULL
137: , attribute_category ic_item_mst.attribute_category%TYPE DEFAULT NULL
138: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
139: , ont_pricing_qty_source ic_item_mst.ont_pricing_qty_source%TYPE DEFAULT 0
140: , gl_business_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
141: , gl_prod_line mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
142: , sub_standard_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
143: , tech_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL

Line 147: ( item_no ic_item_mst.item_no%TYPE

143: , tech_class mtl_categories_v.category_concat_segs%TYPE DEFAULT NULL
144: );
145:
146: TYPE lot_rec_typ IS RECORD
147: ( item_no ic_item_mst.item_no%TYPE
148: , lot_no ic_lots_mst.lot_no%TYPE
149: , sublot_no ic_lots_mst.sublot_no%TYPE
150: , lot_desc ic_lots_mst.lot_desc%TYPE
151: , qc_grade ic_lots_mst.qc_grade%TYPE

Line 200: item_no IC_ITEM_MST.item_no%TYPE

196: );
197:
198: TYPE conv_rec_typ IS RECORD
199: (
200: item_no IC_ITEM_MST.item_no%TYPE
201: , lot_no IC_LOTS_MST.lot_no%TYPE DEFAULT NULL
202: , sublot_no IC_LOTS_MST.sublot_no%TYPE DEFAULT NULL
203: , from_uom SY_UOMS_MST.um_code%TYPE
204: , to_uom SY_UOMS_MST.um_code%TYPE

Line 212: , item_no ic_item_mst.item_no%TYPE

208:
209: TYPE qty_rec_typ IS RECORD
210: (
211: trans_type NUMBER(2)
212: , item_no ic_item_mst.item_no%TYPE
213: , journal_no ic_jrnl_mst.journal_no%TYPE
214: , from_whse_code ic_tran_cmp.whse_code%TYPE
215: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL

Line 216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL

212: , item_no ic_item_mst.item_no%TYPE
213: , journal_no ic_jrnl_mst.journal_no%TYPE
214: , from_whse_code ic_tran_cmp.whse_code%TYPE
215: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL

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

213: , journal_no ic_jrnl_mst.journal_no%TYPE
214: , from_whse_code ic_tran_cmp.whse_code%TYPE
215: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL

Line 275: , item_no ic_item_mst.item_no%TYPE

271: (
272: action_code NUMBER(2)
273: , transfer_no ic_xfer_mst.transfer_no%TYPE
274: , orgn_code ic_xfer_mst.orgn_code%TYPE
275: , item_no ic_item_mst.item_no%TYPE
276: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
277: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
278: , release_reason_code ic_xfer_mst.release_reason_code%TYPE DEFAULT NULL
279: , receive_reason_code ic_xfer_mst.receive_reason_code%TYPE DEFAULT NULL

Line 338: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE

334: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
335: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
336: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
337: , p_item_rec IN GMIGAPI.item_rec_typ
338: , x_ic_item_mst_row OUT NOCOPY ic_item_mst%ROWTYPE
339: , x_ic_item_cpg_row OUT NOCOPY ic_item_cpg%ROWTYPE
340: , x_return_status OUT NOCOPY VARCHAR2
341: , x_msg_count OUT NOCOPY NUMBER
342: , x_msg_data OUT NOCOPY VARCHAR2

Line 351: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

347: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
348: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
349: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
350: , p_lot_rec IN lot_rec_typ
351: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
352: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
353: , x_ic_lots_mst_row OUT NOCOPY ic_lots_mst%ROWTYPE
354: , x_ic_lots_cpg_row OUT NOCOPY ic_lots_cpg%ROWTYPE
355: , x_return_status OUT NOCOPY VARCHAR2

Line 366: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

362: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
363: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
364: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
365: , p_conv_rec IN GMIGAPI.conv_rec_typ
366: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
367: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
368: , x_ic_item_cnv_row OUT NOCOPY ic_item_cnv%ROWTYPE
369: , x_return_status OUT NOCOPY VARCHAR2
370: , x_msg_count OUT NOCOPY NUMBER

Line 380: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

376: , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
377: , p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
378: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
379: , p_qty_rec IN GMIGAPI.qty_rec_typ
380: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
381: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
382: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
383: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
384: , x_ic_jrnl_mst_row OUT NOCOPY ic_jrnl_mst%ROWTYPE

Line 398: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE

394: , p_init_msg_list IN VARCHAR2
395: , p_commit IN VARCHAR2
396: , p_validation_level IN NUMBER
397: , p_xfer_rec IN GMIGAPI.xfer_rec_typ
398: , p_ic_item_mst_row IN ic_item_mst%ROWTYPE
399: , p_ic_item_cpg_row IN ic_item_cpg%ROWTYPE
400: , p_ic_lots_mst_row IN ic_lots_mst%ROWTYPE
401: , p_ic_lots_cpg_row IN ic_lots_cpg%ROWTYPE
402: , p_ic_xfer_mst_row OUT NOCOPY ic_xfer_mst%ROWTYPE