APPS.BOM_DIAGUNITTEST_TSDATA dependencies on MTL_SYSTEM_ITEMS_B

Line 47: FROM mtl_system_items_b

43: AND data_type in ( 'VARCHAR2' , 'CHAR');
44:
45: CURSOR c_item_valid (cp_n_item_id IN NUMBER, cp_n_org_id IN NUMBER) IS
46: SELECT count(*)
47: FROM mtl_system_items_b
48: WHERE inventory_item_id = cp_n_item_id
49: AND organization_id = nvl(cp_n_org_id,organization_id);
50:
51: BEGIN

Line 131:
(E.g.) If for mtl_system_items_b table,

127:
then the record with the offending column
128:
needs to be updated so that the columns with
129:
the trailing spaces are trimmed for this specific record.
130:

131:
(E.g.) If for mtl_system_items_b table,
132:
a record is fetched with
133:
Inventory Item Id = 1234
134:
Organization id = 100
135:
Column Name = Attribute1

Line 140:
1. Table name: Enter the table name fetched above (e.g.)mtl_system_items_b

136:
Column Value = ''column with trailing space ''
137:

138:
Use file "afchrchk.sql" present in $FND_TOP/sql to trim the trailing spaces.
139:
This script will ask for the following input.
140:
1. Table name: Enter the table name fetched above (e.g.)mtl_system_items_b
141:
2. Column name: Enter the column name fetched above (e.g.) Attribute1
142:
3. Check for newline characters (Y/N)?: Enter as N
143:
4. Automatically fix all errors found (Y/N)? Enter as Y
144:

Line 172: /* Script to verify records in mtl_system_items_b table */

168: );
169:
170: /*JTF_DIAGNOSTIC_COREAPI.Line_Out(' l_oracle_schema: '||l_oracle_schema);*/
171:
172: /* Script to verify records in mtl_system_items_b table */
173: Begin
174: delete from bom_diag_temp_tab; -- Clear the temporary tables
175: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_B',l_oracle_schema) Loop
176: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);

Line 175: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_B',l_oracle_schema) Loop

171:
172: /* Script to verify records in mtl_system_items_b table */
173: Begin
174: delete from bom_diag_temp_tab; -- Clear the temporary tables
175: For l_varchar_col_rec in c_varchar_cols_cur('MTL_SYSTEM_ITEMS_B',l_oracle_schema) Loop
176: --JTF_DIAGNOSTIC_COREAPI.Line_Out('Column: '||l_varchar_col_rec.column_name);
177:
178: sql_stmt := '';
179: sql_stmt :=' Insert into bom_diag_temp_tab (Inventory_item_id, organization_id, '||

Line 185: ' FROM MTL_SYSTEM_ITEMS_B msib '||

181: ' SELECT msib.inventory_item_id '||
182: ' ,msib.organization_id '||
183: ' ,'''||l_varchar_col_rec.column_name||''' '||
184: ' ,msib.'||l_varchar_col_rec.column_name||' '||
185: ' FROM MTL_SYSTEM_ITEMS_B msib '||
186: ' WHERE msib.organization_id = '||l_org_id||' '||
187: ' AND msib.inventory_item_id ='||l_item_id||' '||
188: ' AND msib.'||l_varchar_col_rec.column_name||' LIKE ''% '' '||
189: ' AND rownum < '||(row_limit/25);

Line 207: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');

203:
204: sqltxt := sqltxt || ' and rownum< '||row_limit;
205: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col1';
206:
207: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');
208: If (num_rows = row_limit -1 ) Then
209: JTF_DIAGNOSTIC_COREAPI.Line_Out('
Output of the above table is limited to the first '||(row_limit-1)||' rows to prevent an excessively big output file.
');
210: End If;
211: statusStr := 'SUCCESS';

Line 215: /* End of mtl_system_items_b script */

211: statusStr := 'SUCCESS';
212: isFatal := 'FALSE';
213:
214: End;
215: /* End of mtl_system_items_b script */
216:
217: /* Script to verify records in mtl_system_items_tl table */
218: Begin
219: delete from bom_diag_temp_tab; -- Clear the temporary tables