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.OKS_AUTH_UTIL_PVT dependencies on CSI_ITEM_INSTANCES

Line 52: TYPE get_prod_rec IS RECORD ( id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,

48:
49: -- BUG 4372877 --
50: -- GCHADHA --
51: -- 5/25/2005 --
52: TYPE get_prod_rec IS RECORD ( id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
53: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
54: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,

Line 53: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,

49: -- BUG 4372877 --
50: -- GCHADHA --
51: -- 5/25/2005 --
52: TYPE get_prod_rec IS RECORD ( id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
53: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
54: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
57: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,

Line 54: quantity CSI_ITEM_INSTANCES.quantity%TYPE,

50: -- GCHADHA --
51: -- 5/25/2005 --
52: TYPE get_prod_rec IS RECORD ( id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
53: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
54: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
57: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
58: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

Line 55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,

51: -- 5/25/2005 --
52: TYPE get_prod_rec IS RECORD ( id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
53: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
54: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
57: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
58: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
59: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,

Line 56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,

52: TYPE get_prod_rec IS RECORD ( id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
53: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
54: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
57: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
58: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
59: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
60: id2 VARCHAR2(1),

Line 58: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

54: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
57: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
58: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
59: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
60: id2 VARCHAR2(1),
61: oe_line_id NUMBER,
62: external_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new

Line 59: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,

55: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
56: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
57: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
58: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
59: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
60: id2 VARCHAR2(1),
61: oe_line_id NUMBER,
62: external_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new
63:

Line 62: external_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new

58: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
59: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
60: id2 VARCHAR2(1),
61: oe_line_id NUMBER,
62: external_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new
63:
64: );
65:
66: -- END GCHADHA --

Line 71: TYPE prod_rec IS RECORD (config_parent_id CSI_ITEM_INSTANCES.instance_id%TYPE,

67:
68: -- BUG 4372877 --
69: -- GCHADHA --
70: -- 5/25/2005 --
71: TYPE prod_rec IS RECORD (config_parent_id CSI_ITEM_INSTANCES.instance_id%TYPE,
72: id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
73: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,

Line 72: id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,

68: -- BUG 4372877 --
69: -- GCHADHA --
70: -- 5/25/2005 --
71: TYPE prod_rec IS RECORD (config_parent_id CSI_ITEM_INSTANCES.instance_id%TYPE,
72: id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
73: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,

Line 73: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,

69: -- GCHADHA --
70: -- 5/25/2005 --
71: TYPE prod_rec IS RECORD (config_parent_id CSI_ITEM_INSTANCES.instance_id%TYPE,
72: id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
73: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
77: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,

Line 74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,

70: -- 5/25/2005 --
71: TYPE prod_rec IS RECORD (config_parent_id CSI_ITEM_INSTANCES.instance_id%TYPE,
72: id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
73: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
77: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
78: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

Line 75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,

71: TYPE prod_rec IS RECORD (config_parent_id CSI_ITEM_INSTANCES.instance_id%TYPE,
72: id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
73: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
77: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
78: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
79: parent_inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

Line 76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,

72: id1 CSI_ITEM_INSTANCES.instance_ID%TYPE ,
73: install_location_Id CSI_ITEM_INSTANCES.install_location_id%TYPE,
74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
77: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
78: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
79: parent_inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
80: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,

Line 78: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

74: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
77: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
78: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
79: parent_inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
80: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
81: id2 VARCHAR2(1),
82: oe_line_id NUMBER ,

Line 79: parent_inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

75: instance_number CSI_ITEM_INSTANCES.instance_number%TYPE,
76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
77: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
78: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
79: parent_inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
80: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
81: id2 VARCHAR2(1),
82: oe_line_id NUMBER ,
83: model_level NUMBER,

Line 80: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,

76: unit_of_measure CSI_ITEM_INSTANCES.unit_of_measure%Type,
77: unit_selling_price OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
78: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
79: parent_inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
80: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
81: id2 VARCHAR2(1),
82: oe_line_id NUMBER ,
83: model_level NUMBER,
84: external_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new

Line 84: external_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new

80: serial_number CSI_ITEM_INSTANCES.serial_number%TYPE,
81: id2 VARCHAR2(1),
82: oe_line_id NUMBER ,
83: model_level NUMBER,
84: external_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new
85: );
86: TYPE prod_tbl is Table of prod_rec INDEX BY BINARY_INTEGER;
87: -- END GCHADHA --
88:

Line 123: ser_number CSI_ITEM_INSTANCES.serial_Number%TYPE,

119: rec_type Varchar2(1),
120: config_parent_id Number,
121: cp_id Number,
122: cp_id2 Varchar2(1),
123: ser_number CSI_ITEM_INSTANCES.serial_Number%TYPE,
124: ref_number CSI_ITEM_INSTANCES.instance_Number%TYPE,
125: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
126: site_id CSI_ITEM_INSTANCES.install_location_id%TYPE,
127: site_name VARCHAR2(2000), -- Bug 4915711

Line 124: ref_number CSI_ITEM_INSTANCES.instance_Number%TYPE,

120: config_parent_id Number,
121: cp_id Number,
122: cp_id2 Varchar2(1),
123: ser_number CSI_ITEM_INSTANCES.serial_Number%TYPE,
124: ref_number CSI_ITEM_INSTANCES.instance_Number%TYPE,
125: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
126: site_id CSI_ITEM_INSTANCES.install_location_id%TYPE,
127: site_name VARCHAR2(2000), -- Bug 4915711
128: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

Line 125: quantity CSI_ITEM_INSTANCES.quantity%TYPE,

121: cp_id Number,
122: cp_id2 Varchar2(1),
123: ser_number CSI_ITEM_INSTANCES.serial_Number%TYPE,
124: ref_number CSI_ITEM_INSTANCES.instance_Number%TYPE,
125: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
126: site_id CSI_ITEM_INSTANCES.install_location_id%TYPE,
127: site_name VARCHAR2(2000), -- Bug 4915711
128: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
129: id Number,

Line 126: site_id CSI_ITEM_INSTANCES.install_location_id%TYPE,

122: cp_id2 Varchar2(1),
123: ser_number CSI_ITEM_INSTANCES.serial_Number%TYPE,
124: ref_number CSI_ITEM_INSTANCES.instance_Number%TYPE,
125: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
126: site_id CSI_ITEM_INSTANCES.install_location_id%TYPE,
127: site_name VARCHAR2(2000), -- Bug 4915711
128: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
129: id Number,
130: name Varchar2(2000), -- Bug 4915711 --

Line 128: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,

124: ref_number CSI_ITEM_INSTANCES.instance_Number%TYPE,
125: quantity CSI_ITEM_INSTANCES.quantity%TYPE,
126: site_id CSI_ITEM_INSTANCES.install_location_id%TYPE,
127: site_name VARCHAR2(2000), -- Bug 4915711
128: inventory_item_id CSI_ITEM_INSTANCES.inventory_item_id%TYPE,
129: id Number,
130: name Varchar2(2000), -- Bug 4915711 --
131: display_name Varchar2(2000), -- Bug 4915711 --
132: description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE,

Line 133: uom_code CSI_ITEM_INSTANCES.unit_of_measure%TYPE,

129: id Number,
130: name Varchar2(2000), -- Bug 4915711 --
131: display_name Varchar2(2000), -- Bug 4915711 --
132: description OKC_K_LINES_V.ITEM_DESCRIPTION%TYPE,
133: uom_code CSI_ITEM_INSTANCES.unit_of_measure%TYPE,
134: orig_net_amt OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
135: price Number,
136: model_level Number,
137: ext_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new

Line 137: ext_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new

133: uom_code CSI_ITEM_INSTANCES.unit_of_measure%TYPE,
134: orig_net_amt OE_ORDER_LINES_ALL.unit_selling_price%TYPE,
135: price Number,
136: model_level Number,
137: ext_reference CSI_ITEM_INSTANCES.external_reference%TYPE -- new
138: );
139: -- END GCHADHA --
140:
141: TYPE prod_selections_tbl IS TABLE OF prod_selections_rec INDEX BY BINARY_INTEGER;