APPS.INV_LOT_SEL_ATTR dependencies on MTL_SERIAL_NUMBERS

Line 69: FROM mtl_serial_numbers

65: AND organization_id = org_id;
66: ELSIF (flex_name = 'Serial Attributes') THEN
67: SELECT serial_attribute_category
68: INTO context_value
69: FROM mtl_serial_numbers
70: WHERE serial_number = p_lot_serial_number
71: AND inventory_item_id = item_id
72: AND current_organization_id = org_id;
73: END IF;

Line 216: FROM mtl_serial_numbers

212: l_progress_indicator := '20';
213:
214: SELECT serial_attribute_category
215: INTO l_context_value
216: FROM mtl_serial_numbers
217: WHERE serial_number = p_lot_serial
218: AND inventory_item_id = item_id
219: AND current_organization_id = org_id;
220:

Line 350: elsif( upper(p_table_name) = 'MTL_SERIAL_NUMBERS' ) then

346: x_column_type := l_retDate;
347: else
348: x_column_type := NULL;
349: end if;
350: elsif( upper(p_table_name) = 'MTL_SERIAL_NUMBERS' ) then
351: if( upper(p_column_name) = 'SERIAL_ATTRIBUTE_CATEGORY' )then
352: x_column_type := l_retVarchar;
353: elsif( upper(p_column_name) = 'ORIGINATION_DATE') then
354: x_column_type := l_retDate;

Line 1272: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

1268: 'from mtl_lot_numbers ' ||
1269: 'where lot_number = :b_lot_number ' ||
1270: 'and inventory_item_id = :b_item_id ' ||
1271: 'and organization_id = :b_org_id ' ;
1272: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1273: l_sel_stmt := l_sel_stmt || ' ' ||
1274: 'from mtl_serial_numbers ' ||
1275: 'where serial_number = :b_serial_number ' ||
1276: 'and inventory_item_id = :b_item_id ' ||

Line 1274: 'from mtl_serial_numbers ' ||

1270: 'and inventory_item_id = :b_item_id ' ||
1271: 'and organization_id = :b_org_id ' ;
1272: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1273: l_sel_stmt := l_sel_stmt || ' ' ||
1274: 'from mtl_serial_numbers ' ||
1275: 'where serial_number = :b_serial_number ' ||
1276: 'and inventory_item_id = :b_item_id ' ||
1277: 'and CURRENT_organization_id = :b_org_id ' ;
1278: END IF;

Line 1289: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

1285: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1286:
1287: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1288: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1289: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1290: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);
1291: END IF;
1292:
1293: l_colnum := 0;

Line 1700: FROM mtl_SERIAL_numbers

1696: ,attribute12
1697: ,attribute13
1698: ,attribute14
1699: ,attribute15
1700: FROM mtl_SERIAL_numbers
1701: WHERE inventory_item_id = p_inventory_item_id
1702: AND SERIAL_number = p_serial_number;
1703: /*
1704: CURSOR inv_ship_attr IS

Line 1720: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1716: , nvl(msn.attribute12, msnt.attribute12) attribute12
1717: , nvl(msn.attribute13, msnt.attribute13) attribute13
1718: , nvl(msn.attribute14, msnt.attribute14) attribute14
1719: , nvl(msn.attribute15, msnt.attribute15) attribute15
1720: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1721: WHERE msn.inventory_item_id = p_inventory_item_id
1722: AND msn.serial_number = p_serial_number
1723: AND msnt.transaction_temp_id = p_transaction_temp_id
1724: AND msnt.fm_serial_number = p_serial_number

Line 1744: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1740: ,msnt.attribute12 attribute12
1741: ,msnt.attribute13 attribute13
1742: ,msnt.attribute14 attribute14
1743: ,msnt.attribute15 attribute15
1744: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1745: WHERE msn.inventory_item_id = p_inventory_item_id
1746: AND msn.serial_number = p_serial_number
1747: AND msnt.transaction_temp_id = p_transaction_temp_id
1748: AND msnt.fm_serial_number = p_serial_number

Line 1945: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';

1941: END IF;
1942:
1943: x_return_status := 'S';
1944: l_dflex_r.application_id := 401;
1945: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';
1946: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
1947: l_global_context := l_contexts_dr.global_context;
1948: l_context := l_contexts_dr.context_code(l_global_context);
1949:

Line 2036: desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I' , validation_date => SYSDATE) THEN

2032: fnd_flex_descval.set_context_value(l_context);
2033: end if;
2034: debug('calling fnd_flex_descval.concatenated_values', 'GET_INV_SERIAL_ATTR', 9);
2035: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV',
2036: desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I' , validation_date => SYSDATE) THEN
2037: x_concatenated_values := fnd_flex_descval.concatenated_values;
2038: ELSE
2039:
2040: x_concatenated_values := null;