APPS.BOM_DIAGUNITTEST_TSDATA dependencies on MTL_SYSTEM_ITEMS_B

Line 46: FROM mtl_system_items_b

42: and syn.synonym_name = l_table_name and col.owner = l_owner and col.data_type in ( 'VARCHAR2' , 'CHAR');
43:
44: CURSOR c_item_valid (cp_n_item_id IN NUMBER, cp_n_org_id IN NUMBER) IS
45: SELECT count(*)
46: FROM mtl_system_items_b
47: WHERE inventory_item_id = cp_n_item_id
48: AND organization_id = nvl(cp_n_org_id,organization_id);
49:
50: BEGIN

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

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

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

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

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

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

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

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

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

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

Line 184: ' FROM MTL_SYSTEM_ITEMS_B msib '||

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

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

202:
203: sqltxt := sqltxt || ' and rownum< '||row_limit;
204: sqltxt :=sqltxt||' order by inventory_item_id, organization_id,char_col1';
205:
206: num_rows:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, ' Columns containing Trailing Spaces in mtl_system_items_b table ');
207: If (num_rows = row_limit -1 ) Then
208: 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.
');
209: End If;
210: statusStr := 'SUCCESS';

Line 214: /* End of mtl_system_items_b script */

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