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.INV_ITEM_ATTRIBUTES_PKG dependencies on MTL_ITEM_ATTRIBUTES_TEMP

Line 13: --| retreive the date to populate MTL_ITEM_ATTRIBUTES_TEMP, on |

9: --| Description : Item attribute processor for the Item Attribute copy form. |
10: --| Creates a pl/sql table of records and populates it with |
11: --| information seeded in the AK dictionary. Queries can then |
12: --| be constructed, based on the pl/sql table of records which |
13: --| retreive the date to populate MTL_ITEM_ATTRIBUTES_TEMP, on |
14: --| which the form is based. |
15: --| |
16: --| Revision |
17: --| 13-Sep-00 dherring Created |

Line 29: --| inserted in MTL_ITEM_ATTRIBUTES_TEMP |

25: --| call_item_update |
26: --| 20-FEB-03 vjavli Bug#2808261 fix: organization item records is |
27: --| getting repeated. Found that when there is no |
28: --| item for that organization, it should not be |
29: --| inserted in MTL_ITEM_ATTRIBUTES_TEMP |
30: --| 18-MAR-03 vjavli Bug#2855692 fix: all items should be displayed |
31: --| in the items range for all the organizations |
32: --| procedure: populate_temp_table modified with |
33: --| WHILE loop for the item_cursor |

Line 637: DELETE FROM MTL_ITEM_ATTRIBUTES_TEMP;

633:
634: -- First make sure there is no left over data from a previous
635: -- navigation to this form
636:
637: DELETE FROM MTL_ITEM_ATTRIBUTES_TEMP;
638:
639: l_org_index := p_org_code_list.FIRST;
640: l_org_id := p_org_code_list(l_org_index);
641:

Line 1015: INSERT INTO MTL_ITEM_ATTRIBUTES_TEMP(

1011: );
1012: END IF;
1013:
1014: -- populate the table
1015: INSERT INTO MTL_ITEM_ATTRIBUTES_TEMP(
1016: organization_code
1017: ,organization_id
1018: ,item_code
1019: ,item_id

Line 1052: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP tmp SET ( '

1048:
1049: IF g_att_tab(g_current_att_index).column_type = 1 THEN
1050:
1051:
1052: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP tmp SET ( '
1053: || g_att_tab(g_current_att_index).temp_column_name
1054: || ' ) = '
1055: || ' (SELECT '
1056: || g_att_tab(g_current_att_index).item_column_name

Line 1064: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP TMP SET ( '

1060: || ')';
1061:
1062: EXECUTE IMMEDIATE l_dml_str;
1063: /*myerrams, Modified the following query to use bind variables. Bug: 5001785*/
1064: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP TMP SET ( '
1065: || CONCAT(g_att_tab(g_current_att_index).temp_column_name,'_DSP')
1066: || ' ) = '
1067: || ' (SELECT FND.'
1068: || g_att_tab(g_current_att_index).lookup_column

Line 1087: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP TMP SET ( '

1083: USING g_att_tab(g_current_att_index).lookup_type_value;
1084:
1085: ELSIF g_att_tab(g_current_att_index).column_type = 2 THEN
1086:
1087: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP TMP SET ( '
1088: || g_att_tab(g_current_att_index).temp_column_name
1089: || ' ) = '
1090: || ' (SELECT '
1091: || g_att_tab(g_current_att_index).item_column_name

Line 1099: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP TMP SET ( '

1095: || ')';
1096:
1097: EXECUTE IMMEDIATE l_dml_str;
1098:
1099: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP TMP SET ( '
1100: || CONCAT(g_att_tab(g_current_att_index).temp_column_name,'_DSP')
1101: || ' ) = '
1102: || ' (SELECT FND.'
1103: || g_att_tab(g_current_att_index).lookup_column

Line 1118: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP tmp SET ( '

1114: EXECUTE IMMEDIATE l_dml_str;
1115:
1116: ELSE
1117:
1118: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP tmp SET ( '
1119: || g_att_tab(g_current_att_index).temp_column_name
1120: || ' ) = '
1121: || ' (SELECT '
1122: || g_att_tab(g_current_att_index).item_column_name

Line 1131: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP tmp SET ( '

1127:
1128:
1129: EXECUTE IMMEDIATE l_dml_str;
1130:
1131: l_dml_str := 'UPDATE MTL_ITEM_ATTRIBUTES_TEMP tmp SET ( '
1132: || CONCAT(g_att_tab(g_current_att_index).temp_column_name,'_dsp')
1133: || ' ) = '
1134: || ' (SELECT '
1135: || g_att_tab(g_current_att_index).item_column_name

Line 1168: -- COMMENT : clear MTL_ITEM_ATTRIBUTES_TEMP

1164:
1165: --=========================================================================
1166: -- PROCEDURE : clear_temp_table PUBLIC
1167: -- PARAMETERS :
1168: -- COMMENT : clear MTL_ITEM_ATTRIBUTES_TEMP
1169: -- simple command to purge all records in temp table
1170: -- this may not seem necessary as a temp table loses
1171: -- it's data at the eand of each session.
1172: -- However the session will last until the form is

Line 1185: delete MTL_ITEM_ATTRIBUTES_TEMP;

1181: IS
1182:
1183: BEGIN
1184:
1185: delete MTL_ITEM_ATTRIBUTES_TEMP;
1186:
1187: commit;
1188:
1189: EXCEPTION

Line 2114: -- the MTL_ITEM_ATTRIBUTES_TEMP table as the attributes names

2110:
2111: -- populate the item values temp table with the names and values
2112: -- of the attributes that need to be copied.
2113: -- This information can not be read directly from
2114: -- the MTL_ITEM_ATTRIBUTES_TEMP table as the attributes names
2115: -- have been assigned dynamically. for more please read the dld
2116:
2117: LOOP
2118:

Line 2139: -- mtl_item_attributes_temp.

2135:
2136: -- populate the update records table with the organization id and the
2137: -- item id of all the records to be copied to.
2138: -- This information can be read directly from the table
2139: -- mtl_item_attributes_temp.
2140:
2141: INSERT into mtl_update_records_temp(
2142: item_update_id
2143: ,inventory_item_id

Line 2150: mtl_item_attributes_temp mia

2146: l_seq_id
2147: ,mia.item_id
2148: ,mia.organization_id
2149: FROM
2150: mtl_item_attributes_temp mia
2151: WHERE mia.checkbox = 'Y';
2152:
2153: -- return the sequence id
2154: x_seq_id := l_seq_id;